Re: Selective sequence..

From: Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in>
To: Timo Tuomi <timo(dot)tuomi(at)sllpilots(dot)fi>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Selective sequence..
Date: 2002-12-11 08:07:48
Message-ID: 3DF6F254.4EBFC768@giaspn01.vsnl.net.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Timo

will it work if you select maxval+1 of memberid column for certain
condition, otherwise 0?

Vijay

Timo Tuomi wrote:

> when I add a member it automatically
> inserts a nextval('memberid') into the memberid field ONLY if
> member_role='a_particular_role' otherwise 0.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Conxita Marín 2002-12-11 08:21:03 plpgsql: How to catch error when I drop an inexistent table?
Previous Message Sol 2002-12-11 04:14:17 Re: How many connections can a Postgress database support...