Define this as function: SELECT COUNT(t.techid) FROM ticket t WHERE t.techid = $1 Then use this.... SELECT u.idnum, u.username, func(u.idnum) FROM users u; -------------------------------------------------------------- The reboots are for hardware upgrades! "http://www.nmmm.nu; <[EMAIL PROTECTED]> ----- Original Message ----- From: Tom Lane <[EMAIL PROTECTED]> To: Lars <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: вторник, Февруари 08, 2000 05:33 Subject: Re: [SQL] SubSelect as a column > Lars <[EMAIL PROTECTED]> writes: > > I am trying to use a subselect as a column name, but it appears as if this > > is not supported in Postgresql. Here is the query: > > > SELECT u.idnum, u.username, > > (SELECT COUNT(t.techid) > > FROM ticket t > > WHERE t.techid = u.idnum) > > FROM users u; > > Nope, doesn't work in 6.5.*. It is there in current sources for the > upcoming 7.0 release. Can't think of any good workaround in 6.5... > > regards, tom lane > > ************ ************
