Re: [SQL] error with mor than 1 sub-select

Actually, it pointed you right to it. Notice that exits is just before where the pointer was. chrisj wrote: thanks, stupid user error. i guess the pointer on the error message led me astray Michael Fuhr wrote: On Tue, Aug 22, 2006 at 06:47:51PM -0700, chrisj wrote: The first query

Re: [SQL] error with mor than 1 sub-select

thanks, stupid user error. i guess the pointer on the error message led me astray Michael Fuhr wrote: > > On Tue, Aug 22, 2006 at 06:47:51PM -0700, chrisj wrote: >> The first query works fine, but when a second sub-query is added I get a >> syntax error... >> >> psql protocal2 -U p2user << EO

Re: [SQL] error with mor than 1 sub-select

chrisj <[EMAIL PROTECTED]> escreveu: Hi,I am fairly new to PostgreSQL but not to SQL. Is this a bug or alimitation...The first query works fine, but when a second sub-query is added I get asyntax error...psql protocal2 -U p2user << EOF1select * from serv_res SR where serv_key = 10

Re: [SQL] error with mor than 1 sub-select

On Tue, Aug 22, 2006 at 06:47:51PM -0700, chrisj wrote: > The first query works fine, but when a second sub-query is added I get a > syntax error... > > psql protocal2 -U p2user << EOF1 > select * >from serv_res SR >where serv_key = 10 > and not exists > (

[SQL] error with mor than 1 sub-select

Hi, I am fairly new to PostgreSQL but not to SQL. Is this a bug or a limitation... The first query works fine, but when a second sub-query is added I get a syntax error... psql protocal2 -U p2user << EOF1 select * from serv_res SR where serv_key = 10 and not exists