Mitchell Vincent skrev:
> SELECT c.customer_id as customer_id,c.customer_number as customer_number,
> c.customer_name as customer_name,c.customer_status as
> customer_status,cat.category_name as category_name,
> c.bill_state as bill_state, coalesce(ctots.balance_due, 0.00) as
> balance FROM custome
SELECT c.customer_id as customer_id,c.customer_number as customer_number,
c.customer_name as customer_name,c.customer_status as
customer_status,cat.category_name as category_name,
c.bill_state as bill_state, coalesce(ctots.balance_due, 0.00) as
balance FROM customers as c,
customer_categories as ca
On Jul 29, 2007, at 7:00 , roopa perumalraja wrote:
I would like to know if its possible to increment the primary key
field value of stocks table without using sequences by getting the
next value of the pk field from the sequnce table ?
Why? Any other solution will cause performance issues
Hi, Marcin
I'm not familiar with PREPARE TRANSACTION maby it could be done in that way.
But, you can use a EXCEPTION clause, and there put your insert.
IF EXISTS (SELECT 1 FROM g.m_lista WHERE idf = NEW.id) THEN
RAISE EXCEPTION 'CENY NIE SPELNIAJA WARUNKOW! %',
rtrim(bledn
Hi all,
I would like to know if its possible to increment the primary key field value
of stocks table without using sequences by getting the next value of the pk
field from the sequnce table ?
insert into stocks (prim_id, date,time, code, price, volume) (select .
from temp_stocks
