On Tue, Mar 26, 2013 at 12:47 PM, Bill Moran <wmoran(at)potentialtech(dot)com> wrote:
>
> psql -U postgres
> psql (9.2.3)
> Type "help" for help.
>
> postgres=# select encode('can''t', 'escape');
> encode
> --------
> can't
> (1 row)
>
> I observed the same behaviour on one of our older systems (8.3.11) as well.
>
> Am I missing something? I expected "can''t" as the output.
why? that isn't what you passed it. the input string doubled single
quotes is converted to single single quote per spec. it's 'ghetto
escaping'.
merlin