Is this what you are wanting?
select coalesce(form.titleField, form.title) as Value
This will give you form.titleField, but if it is null, return form.title
----- Original Message -----
From: "eric soroos" <eric-psql(at)soroos(dot)net>
Sent: Tuesday, October 15, 2002 10:50 AM
Subject: [NOVICE] Select a column based on a value.
> I've got something like the following where each entry has an associated
form. (a join on entries.formNum=forms.objectNum)
> create table forms (objectNum int, title text, titleField text);
> create table entries (id serial, formNum int, col1 text, col2 text, ...);
> Forms have two types of names, either a static name in the title column or
a reference to a column name in the titleField column (i.e. col1, col2).
I'm looking for a way to have an embedded function pull out the title of the
> In psuedo code:
> entryTitle= if form.titleField is not null then entries.[form.titleField]
> else form.title
> I currently just grab all the possible columns and do the work in the
client, but I'd really like to be able to group by, sort and otherwise
manipulate this in the backend.
> Is there a way to do this? Or am I goign to run up against a hard wall
between code and data?
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-10-15 04:58:16|
|Subject: Re: test geometry ... FAILED |
|Previous:||From: eric soroos||Date: 2002-10-14 21:50:27|
|Subject: Select a column based on a value.|