Hi,
Thanks a lot,
That exactly wat I need
:)
Suad
Chris wrote:
suad wrote:
Hi,
I need some help in sql - postgresql:
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
suad wrote:
Hi,
I need some help in sql - postgresql:
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 be:
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
