"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
"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
"omid omoomi" <[EMAIL PROTECTED]> writes:
> Hi,
> How about ordering by Address_type ? only needs to have 1, 2, 3 as
> different address types in your desired order. like :
>
> select person_id , address where address in not null order by address_type
> limit 1 ;
>
> sure you can change the
Hi,
How about ordering by Address_type ? only needs to have 1, 2, 3 as
different address types in your desired order. like :
select person_id , address where address in not null order by address_type
limit 1 ;
sure you can change the limit if you wish more addresses.
hope that helps
Omid Omo
