Re: [SQL] Select by priority again

2000-07-24 Thread Bernie Huang
"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 m

Re: [SQL] Select by priority again

2000-07-24 Thread D'Arcy J.M. Cain
[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

[SQL] Select by priority again

2000-07-24 Thread 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