Search Postgresql Archives

Re: Function PostgreSQL 9.2

Subject: Re: Function PostgreSQL 9.2
From: John R Pierce <pierce@xxxxxxxxxxxx>
Date: Wed, 4 May 2016 22:01:26 -0700
In-reply-to: <CAE_gQfVW3REAiCTBDQWTLJZRV-xj033pD_YEwB=kqWVEeXJWFg@mail.gmail.com>
User-agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.0

On 5/4/2016 9:56 PM, drum.lucas@xxxxxxxxx wrote:

If I comment the line: ELSEIF NEW.code IS NULL THEN, the data is inserted into the users.code column.

in the table definition, whats the default value of 'code' ?

-- 
john r pierce, recycling bits in santa cruz

References:
- Function PostgreSQL 9.2
  - From: drum.lucas@xxxxxxxxx
- Re: Function PostgreSQL 9.2
  - From: Melvin Davidson
- Re: Function PostgreSQL 9.2
  - From: drum.lucas@xxxxxxxxx
- Re: Function PostgreSQL 9.2
  - From: Adrian Klaver
- Re: Function PostgreSQL 9.2
  - From: Melvin Davidson
- Re: Function PostgreSQL 9.2
  - From: drum.lucas@xxxxxxxxx
- Re: Function PostgreSQL 9.2
  - From: Melvin Davidson
- Re: Function PostgreSQL 9.2
  - From: David G. Johnston
- Re: Function PostgreSQL 9.2
  - From: drum.lucas@xxxxxxxxx
- Re: Function PostgreSQL 9.2
  - From: David G. Johnston
- Re: Function PostgreSQL 9.2
  - From: Berend Tober
- Re: Function PostgreSQL 9.2
  - From: drum.lucas@xxxxxxxxx
- Re: Function PostgreSQL 9.2
  - From: David G. Johnston
- Re: Function PostgreSQL 9.2
  - From: Berend Tober
- Re: Function PostgreSQL 9.2
  - From: drum.lucas@xxxxxxxxx