Re: odbc (was: Re: [HACKERS] ascii to character conversion in postgres)

2000-09-19 Thread Peter Eisentraut
Karel Zak writes: > I don't want make some changes to contrib/odbc, because it's out of > me... but I have a question, Why in the contrib/odbc/odbc.c are total > same function as in oracle_compat.c (like ascii(), ichar(), repeat())? The odbc.c file is for installing the set of ODBC compatibil

Re: odbc (was: Re: [HACKERS] ascii to character conversion in postgres)

2000-09-19 Thread Tom Lane
Karel Zak <[EMAIL PROTECTED]> writes: > I don't want make some changes to contrib/odbc, because it's out of > me... but I have a question, Why in the contrib/odbc/odbc.c are total > same function as in oracle_compat.c (like ascii(), ichar(), repeat())? contrib/odbc was a quick hack just before

Re: [HACKERS] ascii to character conversion in postgres

2000-09-19 Thread Tom Lane
Alex Sokoloff <[EMAIL PROTECTED]> writes: > Of course, if an alias for ichar is carried forward I > can write code for the current postgres that won't > break with future releases. I realize that I might end > up being the only person on the planet who ends up > using ichar, and that may not be su

odbc (was: Re: [HACKERS] ascii to character conversion in postgres)

2000-09-19 Thread Karel Zak
> New proposal: forget ichar(), give the function two entries chr() and > char(). OK, I will send patch for this and send domumentation for all oracle_compat.c routines... I don't want make some changes to contrib/odbc, because it's out of me... but I have a question, Why in the contrib/odbc

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread Alex Sokoloff
Of course, if an alias for ichar is carried forward I can write code for the current postgres that won't break with future releases. I realize that I might end up being the only person on the planet who ends up using ichar, and that may not be sufficient justification for an alias Best, Alex

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread Peter Eisentraut
I wrote: > ichar() is for ODBC compliance. chr() could probably be an alias to it. Ignore that. Probably "char()" had some parsing or overloading problems. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread Peter Eisentraut
Tom Lane writes: > ichar(). Since that's part of the "oracle_compatibility" file, > I'd assumed the function name spelling was the same as Oracle's. > Not so? ichar() is for ODBC compliance. chr() could probably be an alias to it. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread The Hermit Hacker
On Mon, 18 Sep 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > > sounds good to me ... chr() == char(), I take it? is there a reason for > > having both vs just changing char() to chr() in the odbc stuff? > > We don't control the ODBC specification ... okay, granted, bu

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread Tom Lane
The Hermit Hacker <[EMAIL PROTECTED]> writes: > sounds good to me ... chr() == char(), I take it? is there a reason for > having both vs just changing char() to chr() in the odbc stuff? We don't control the ODBC specification ... regards, tom lane

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread The Hermit Hacker
On Mon, 18 Sep 2000, Tom Lane wrote: > The Hermit Hacker <[EMAIL PROTECTED]> writes: > >> I vote for just renaming it to chr(). Any objections? > > > first thing off the top of my head ... was there a reason why it was added > > to contrib/odbc? ignoring the "oracle documentation", is it somet

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread Tom Lane
The Hermit Hacker <[EMAIL PROTECTED]> writes: >> I vote for just renaming it to chr(). Any objections? > first thing off the top of my head ... was there a reason why it was added > to contrib/odbc? ignoring the "oracle documentation", is it something > that is/was needed for ODBC? Now that I

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread The Hermit Hacker
On Mon, 18 Sep 2000, Tom Lane wrote: > Karel Zak <[EMAIL PROTECTED]> writes: > > Not documented (from oracle_compat.c) in PG documentation: > > btrim() > > ascii() > > ichar() > > repeat() > > and about ichar() is nothing in Oracle documentation, it's knows chr() > > only... >

Re: [HACKERS] ascii to character conversion in postgres

2000-09-18 Thread Tom Lane
Karel Zak <[EMAIL PROTECTED]> writes: > Not documented (from oracle_compat.c) in PG documentation: > btrim() > ascii() > ichar() > repeat() > and about ichar() is nothing in Oracle documentation, it's knows chr() > only... Sounds to me like calling it ichar() was an err

Re: [HACKERS] ascii to character conversion in postgres

2000-09-17 Thread Karel Zak
On Sun, 17 Sep 2000, Tom Lane wrote: > >> Postgres has an 'ascii' function that converts > >> characters to ascii, values, but it appears to be a > >> one way street. I can't find a way to convert ascii > >> values to characters, like 'chr' in Oracle. Anyone > >> know how to do this? > > ichar

Re: [HACKERS] ascii to character conversion in postgres

2000-09-17 Thread Tom Lane
>> Postgres has an 'ascii' function that converts >> characters to ascii, values, but it appears to be a >> one way street. I can't find a way to convert ascii >> values to characters, like 'chr' in Oracle. Anyone >> know how to do this? ichar(). Since that's part of the "oracle_compatibility"

Re: [HACKERS] ascii to character conversion in postgres

2000-09-17 Thread Karel Zak
On Sat, 16 Sep 2000, Alex Sokoloff wrote: > Postgres has an 'ascii' function that converts > characters to ascii, values, but it appears to be a > one way street. I can't find a way to convert ascii > values to characters, like 'chr' in Oracle. Anyone > know how to do this? Interesting for me

[HACKERS] ascii to character conversion in postgres

2000-09-16 Thread Alex Sokoloff
Postgres has an 'ascii' function that converts characters to ascii, values, but it appears to be a one way street. I can't find a way to convert ascii values to characters, like 'chr' in Oracle. Anyone know how to do this? -Alex __ Do You Yahoo!?