Lars <lars(at)sscsinc(dot)com> 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