Re: [SQL] select and as doubt

2006-01-23 Thread Bruno Wolff III
On Sun, Jan 15, 2006 at 12:59:48 -0200, Alexandre Gonçalves Jacarandá <[EMAIL PROTECTED]> wrote: > Thanks for reply Tom, but which docs should I read for that ? The documentation for whatever ever programming language you will be using to generate the queries. > > Tom Lane escreveu: > > =?ISO-

Re: [SQL] select and as doubt

2006-01-15 Thread Alexandre Gonçalves Jacarandá
Thanks for reply Tom, but which docs should I read for that ? Tom Lane escreveu: > =?ISO-8859-1?Q?Alexandre_Gon=E7alves_Jacarand=E1?= <[EMAIL PROTECTED]> writes: > >>It's possible to make an SELECT inside an AS clause ? > > > No. You could try building the query as a string. > >

Re: [SQL] select and as doubt

2006-01-14 Thread Tom Lane
=?ISO-8859-1?Q?Alexandre_Gon=E7alves_Jacarand=E1?= <[EMAIL PROTECTED]> writes: > It's possible to make an SELECT inside an AS clause ? No. You could try building the query as a string. regards, tom lane ---(end of broadcast)---

[SQL] select and as doubt

2006-01-14 Thread Alexandre Gonçalves Jacarandá
Hello folks!!! I've a question that could be very strange: It's possible to make an SELECT inside an AS clause ? ex.: select student_id, subject_name_id, grade as (select subject_name from subject_names) from grades; The wy is that i've a table with subject names and another with name_id and grad