Skip site navigation (1) Skip section navigation (2)

Select a column based on a value.

From: eric soroos <eric-psql(at)soroos(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Select a column based on a value.
Date: 2002-10-14 21:50:27
Message-ID: 1668721.1177515469@[4.42.179.151] (view raw or whole thread)
Thread:
Lists: pgsql-novice
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 entry.

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?

eric






Responses

pgsql-novice by date

Next:From: Mark WilsonDate: 2002-10-14 22:05:39
Subject: Re: Select a column based on a value.
Previous:From: János LöbbDate: 2002-10-14 21:02:23
Subject: test geometry ... FAILED

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group