Re: Substring result short by 1

From: "gnari" <gnari(at)simnet(dot)is>
To: "David Filion" <david(at)filiontech(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Substring result short by 1
Date: 2004-08-31 19:53:22
Message-ID: 001c01c48f94$2ba74210$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "David Filion" <david(at)filiontech(dot)com>

>
> prepaid=# select substring('15148300', 0, 5);

try substring('15148300', 1, 5);

gnari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message gnari 2004-08-31 19:55:34 Re: About "lock file postmaster.pid" Error , cannot setup postmaster
Previous Message Kevin Murphy 2004-08-31 19:50:00 zombie primary key lurches out of database to devour the brains of the unwary