Re: Insert character codes in PosgreSQL with SQL command

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Sanjin <sanjin(dot)m(at)SoftHome(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Insert character codes in PosgreSQL with SQL command
Date: 2001-12-14 14:31:20
Message-ID: 20011214062353.R11758-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Thu, 13 Dec 2001, Sanjin wrote:

> Hi,
>
> Is it possible to insert character/s based on their character codes into
> PosgreSQL with some SQL command?
>
> i.e. INSERT INTO target_table VALUES 0x61 0x62 0x63 (values of characters
> codes, not characters i.e. 'abc').

There should be a chr() function that gives back the character with a
given code.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-12-14 14:35:36 Re: alias question
Previous Message Martin Weinberg 2001-12-14 13:59:40 Problem with OID wrap