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

Re: Select by priority again

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select by priority again
Date: 2000-07-24 21:15:31
Message-ID: 397CB1F3.8B974506@ec.gc.ca (view raw or flat)
Thread:
Lists: pgsql-sql
"D'Arcy J.M. Cain" wrote:

>      [Note:  PHP mailing list removed from Cc as this is strictly a
>       PostgreSQL question I think.]
>
> Thus spake Bernie Huang
> > Sorry about this, but I don't quite get previous postings regarding
> > select by prioriry.
> >
> > I have the same question with my sql. I want to be able to select
> > cell_phone if there is one in the table; otherwise, I will select
> > work_phone.
> >
> > table
> > ------
> > id, name, address, cell_phone, work_phone,...
> >
> > and I tried using "case when...end" but nope, it's not gonna work. Help
> > is needed. Thanks.
>
> Exactly what was the SQL statement and which version of PostgreSQL?  I
> do this in a view and it works.
>
>     SELECT CASE WHEN login IS NULL THEN uid::text ELSE login END AS login
>     FROM account;
>
> --
> D'Arcy J.M. Cain <darcy(at){druid|vex}.net>   |  Democracy is three wolves
> http://www.druid.net/darcy/                |  and a sheep voting on
> +1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.

hi, thanks for the help.  I will avoid to CC to the wrong list.


- Bernie

Attachment: bernie.huang.vcf
Description: text/x-vcard (315 bytes)

In response to

pgsql-sql by date

Next:From: Jesus AneirosDate: 2000-07-24 22:25:03
Subject: RULES on PostgreSQL
Previous:From: D'Arcy J.M. CainDate: 2000-07-24 19:20:46
Subject: Re: Select by priority again

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