"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
[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
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
"Gary J. Farmer" <[EMAIL PROTECTED]> writes:
> >> I think the order thing will work though I have no choice of using
> >> numbering for the address_type as I am working off a pre-existing
> >> database. They are using a mnemonic char type. I am essentially batch
> >> downloading and processin
>> I think the order thing will work though I have no choice of using
>> numbering for the address_type as I am working off a pre-existing
>> database. They are using a mnemonic char type. I am essentially batch
>> downloading and processing this and other database tables for query
>> and pre
Prasanth A. Kumar writes:
> I need some suggestions on how to construct a particular select that I
> need. I have a table of addresses where the primary key is the
> persons_id and a address_type field. The address_type field is a
> character which specifies whether the address is for the home, w
limit 1 ;
>
> sure you can change the limit if you wish more addresses.
> hope that helps
> Omid Omoomi
>
> >From: [EMAIL PROTECTED] (Prasanth A. Kumar)
> >To: [EMAIL PROTECTED]
> >Subject: [SQL] Select by priority
> >Date: 15 Jul 2000 10:11:43 -0700
>
Omoomi
>From: [EMAIL PROTECTED] (Prasanth A. Kumar)
>To: [EMAIL PROTECTED]
>Subject: [SQL] Select by priority
>Date: 15 Jul 2000 10:11:43 -0700
>
>I need some suggestions on how to construct a particular select that I
>need. I have a table of addresses where the primary key is
I need some suggestions on how to construct a particular select that I
need. I have a table of addresses where the primary key is the
persons_id and a address_type field. The address_type field is a
character which specifies whether the address is for the home, work,
or mailing. A person can have
