using querys like: 'select table.*'

From: erobles <erobles(at)sensacd(dot)com(dot)mx>
To: pgsql-general(at)postgresql(dot)org
Subject: using querys like: 'select table.*'
Date: 2009-12-02 23:58:02
Message-ID: 4B16FF0A.4000900@sensacd.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Droid Sans">Hi!<br>
<br>
In&nbsp; postgresql 7.2&nbsp; i can use&nbsp; this kind of querys:<br>
<br>
select&nbsp; table.* ; <br>
<br>
select&nbsp; * from&nbsp; table1 where&nbsp; table1.key=othertable.key;<br>
<br>
<br>
but in&nbsp; postgresql 8.3&nbsp; i have&nbsp; an error like this:<br>
ERROR: missing FROM-clause entry for table ...<br>
<br>
<br>
what should i do to solve this?&nbsp; :-)<br>
<br>
<br>
<br>
<br>
<br>
</font>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 586 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message erobles 2009-12-03 00:04:47 Re: using querys like: 'select table.*'
Previous Message Scott Marlowe 2009-12-02 23:51:43 Re: Auto Vacuum Daemon