Re: [SQL] Different type of query

2008-06-11 Thread Steve Crawford
I would like to have multiple values nutrient_no: ndb_no | nutrient_no | nutrient_value +-+ 13473 | 203 | 24.18 13473 | 204 | 15.93 13473 | 205 | 0 13473 | 207 |1.1 13473 | 208

Re: [SQL] Different type of query

2008-06-11 Thread PostgreSQL Admin
Mark Roberts wrote: On Wed, 2008-06-11 at 14:41 -0400, PostgreSQL Admin wrote: I would like to have multiple values nutrient_no: ndb_no | nutrient_no | nutrient_value +-+ 13473 | 203 | 24.18 13473 | 204 | 15.93 13473 |

Re: [SQL] Different type of query

2008-06-11 Thread Mark Roberts
On Wed, 2008-06-11 at 14:41 -0400, PostgreSQL Admin wrote: > I would like to have multiple values nutrient_no: > ndb_no | nutrient_no | nutrient_value > +-+ > 13473 | 203 | 24.18 > 13473 | 204 | 15.93 > 13473 | 205 |

Re: [SQL] Different type of query

2008-06-11 Thread PostgreSQL Admin
Steve Crawford wrote: PostgreSQL Admin wrote: I have a table ... when I run this query: select ndb_no, nutrient_no, nutrient_value from nutrient_data where ndb_no = 13473; it produces: ndb_no | nutrient_no | nutrient_value +-+ 13473 | 203 |

Re: [SQL] Different type of query

2008-06-11 Thread Steve Crawford
PostgreSQL Admin wrote: I have a table ... when I run this query: select ndb_no, nutrient_no, nutrient_value from nutrient_data where ndb_no = 13473; it produces: ndb_no | nutrient_no | nutrient_value +-+ 13473 | 203 | 24.18 ... I want o

[SQL] Different type of query

2008-06-11 Thread PostgreSQL Admin
I have a table like this: usda=# \d nutrient_data Table "public.nutrient_data" Column | Type | Modifiers -+---+--- ndb_no | integer | not null nutrient_no | integer | not null

Re: [SQL] Update and trigger

2008-06-11 Thread A. Kretschmer
am Wed, dem 11.06.2008, um 0:54:55 -0700 mailte Medi Montaseri folgendes: > Thanks...but a difference seems to be that the rule is not specific to update > on a particular col but any col of a row getting updated... > > Thanks Okay, but i havn't an idea. A statement level trigger can't see the

Re: [SQL] Update and trigger

2008-06-11 Thread Medi Montaseri
Thanks...but a difference seems to be that the rule is not specific to update on a particular col but any col of a row getting updated... Thanks On Tue, Jun 10, 2008 at 10:21 PM, A. Kretschmer < [EMAIL PROTECTED]> wrote: > am Tue, dem 10.06.2008, um 18:45:51 -0700 mailte Medi Montaseri folgende