You'll probably want something like null::varchar (or other appropriate
type) for the nulls. It's trying to grab the type from the first
select and can't figure the type out for the null. (Technically
speaking, it's probably supposed to be CAST(NULL AS VARCHAR) to
be technically sql complient,
Hi there, having problems with the following:
On Postgresql (on Linux)
I have 3 tables:
1)employee
firstname
lastname
initials
2)has_title
initials
title
3)has_trade
initials
trade
Now, what I would like is to get a list of all employees with all their titles and
trades - employees can have