[SQL] SELECT * FROM select -- got it!

sorry! infact, i didn't try that with quote. now it is fine.. sorry for ur inconvinence and thankx however. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] SELECT * from select - HOW?

hi, how can we select * from a view named 'select'?? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [SQL] SELECT FROM SELECT

"Aleksey V. Kurinov" <[EMAIL PROTECTED]> writes: > Does Postrges provide "Select * from Select * from t1" construction ? In 7.1. But you have to spell it per the SQL spec: select * from (select * from t1) as foo; The parentheses and alias name are not optional.

[SQL] SELECT FROM SELECT

Hi, All !! Does Postrges provide "Select * from Select * from t1" construction ? I use Postrges v.7.0.3 and get "ERROR: parser: parse error at or near "select" response for such request. Thanks, Leksey