Re: [GENERAL] using querys like: 'select table.*'

2009-12-02 Thread Craig Ringer
On 3/12/2009 7:58 AM, erobles wrote: Hi! In postgresql 7.2 i can use this kind of querys: select table.* ; select * from table1 where table1.key=othertable.key; but in postgresql 8.3 i have an error like this: ERROR: missing FROM-clause entry for table ... what should i do to solve this? :

Re: [GENERAL] using querys like: 'select table.*'

2009-12-02 Thread Adrian Klaver
On Wednesday 02 December 2009 4:04:47 pm erobles wrote: > erobles wrote: > > Hi! > > > > In postgresql 7.2 i can use this kind of querys: > > > > select table.* ; > > > > select * from table1 where table1.key=othertable.key; > > > > > > but in postgresql 8.3 i have an error like this: > >

Re: [GENERAL] using querys like: 'select table.*'

2009-12-02 Thread erobles
erobles wrote: Hi! In postgresql 7.2 i can use this kind of querys: select table.* ; select * from table1 where table1.key=othertable.key; but in postgresql 8.3 i have an error like this: ERROR: missing FROM-clause entry for table ... what should i do to solve this? :-)

[GENERAL] using querys like: 'select table.*'

2009-12-02 Thread erobles
Hi! In  postgresql 7.2  i can use  this kind of querys: select  table.* ; select  * from  table1 where  table1.key=othertable.key; but in  postgresql 8.3  i have  an error like this: ERROR: missing FROM-clause entry for table ... what should i do to solve this?  :-)