Search Postgresql Archives

Re: strpos NOT doing what I'd expect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Ralph Smith <smithrn@xxxxxxxxxxxxxx>
Subject: Re: strpos NOT doing what I'd expect
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Fri, 06 Jun 2008 22:06:27 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Ralph Smith <smithrn@xxxxxxxxxxxxxx> message dated "Fri, 06 Jun 2008 17:58:28 -0700"
In-reply-to: <37C882AE-F4C4-4770-86D9-C4219694BDF7@xxxxxxxxxxxxxx>

Ralph Smith <smithrn@xxxxxxxxxxxxxx> writes:
> DECLARE
>    achar  character := '' ;

Use varchar or text.  character is weird about trailing spaces.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- strpos NOT doing what I'd expect
  - From: Ralph Smith

Prev by Date: Re: PL/pgSQL graph enumeration function hangs
Next by Date: IN vs EXISTS
Previous by thread: strpos NOT doing what I'd expect
Next by thread: Re: strpos NOT doing what I'd expect
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux