Re: interesting sequence (Correctin)

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: John Fabiani <johnf(at)jfcomputer(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: interesting sequence (Correctin)
Date: 2011-07-06 19:38:10
Message-ID: 4E14B9A2.7070907@archidevsys.co.nz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 06/07/11 21:47, Gavin Flower wrote:

I forgot the format required of the order number, so to get the full
yesr, I should have used:
to_char(day, 'YYYYMMDD')

[...]
> v_order_num := type::text ||
> '-' ||
> to_char(day, 'YYMMDD') ||
> '-' ||
> v_seq_new::text;
[...]

Cheers,
Gavin

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2011-07-06 22:06:27 Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?
Previous Message Emi Lu 2011-07-06 19:03:00 Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis?