Hi,
I need some help in sql - postgresql:
I create this 4 tables:
CREATE TABLE a (
a_id SERIAL PRIMARY KEY,
a_name text );
CREATE TABLE b (
b_id SERIAL PRIMARY KEY,
b_price INT2 );
CREATE TABLE c (
c_id SERIAL PRIMARY KEY,
a_id INT4 REFERENCES a ON UPDATE CASCADE ON DELETE CASCADE,
b_id INT4
suad wrote:
Hi,
I need some help in sql - postgresql:
snip
Yay a postgres question! :D hee hee
*The question is* : how can I force that the result of the col payed to
be zerro 0 insted of nothing (NULL)
and the order will be in way that the zerro's values comes first.
and the result will
Hi,
Thanks a lot,
That exactly wat I need
:)
Suad
Chris wrote:
suad wrote:
Hi,
I need some help in sql - postgresql:
snip
Yay a postgres question! :D hee hee
*The question is* : how can I force that the result of the col payed
to be zerro 0 insted of nothing (NULL)
and the order