David Garamond wrote:
2a. individual string values will be tagged with charset+encoding. this
incurs an overhead of 1-2 bytes per value.
forgot to add: this overhead is just for "in-memory" or temporary value
(e.g. when being passed as arguments). in the storage itself, this is
not needed becaus
Stephan Szabo wrote:
Could you point me where in the archives can I read more? I'm having a
bit of trouble finding discussion on this. Thanks.
I didn't spend too much time looking, but there are a few that look like
they'll touch upon related issues:
http://archives.postgresql.org/pgsql-hackers/200
IMHO, no on both questions. There's always danger on relying on the
value of session variables in general in that an application must either
And what if you use a connection sharing/pooling software ? What happens
with the session vars ?
---(end of broadcast)--
On Thu, 5 Aug 2004, David Garamond wrote:
> Stephan Szabo wrote:
> >>in oracle 10g, you can issue:
> >>
> >> ALTER SESSION SET NLS_COMP = ansi;
> >> ALTER SESSION SET NLS_SORT = binary_ci;
> >>
> >>do you think this is an elegant solution for case insensitive sorting &
> >>searching? is there in
Stephan Szabo wrote:
in oracle 10g, you can issue:
ALTER SESSION SET NLS_COMP = ansi;
ALTER SESSION SET NLS_SORT = binary_ci;
do you think this is an elegant solution for case insensitive sorting &
searching? is there interest in seeing this in postgres?
IMHO, no on both questions. There's alway
On Thu, 5 Aug 2004, David Garamond wrote:
> in oracle 10g, you can issue:
>
> ALTER SESSION SET NLS_COMP = ansi;
> ALTER SESSION SET NLS_SORT = binary_ci;
>
> do you think this is an elegant solution for case insensitive sorting &
> searching? is there interest in seeing this in postgres?
IMH
- not transparent
- can't automatically make all values fed to SELECT case-converted
- not transparent
Pierre-Frédéric Caillaud wrote:
create a functional index on lower case value of your column.
ORDER BY lower case value of your column.
in oracle 10g, you can issue:
ALTER SESSION SET N
create a functional index on lower case value of your column.
ORDER BY lower case value of your column.
in oracle 10g, you can issue:
ALTER SESSION SET NLS_COMP = ansi;
ALTER SESSION SET NLS_SORT = binary_ci;
do you think this is an elegant solution for case insensitive sorting &
in oracle 10g, you can issue:
ALTER SESSION SET NLS_COMP = ansi;
ALTER SESSION SET NLS_SORT = binary_ci;
do you think this is an elegant solution for case insensitive sorting &
searching? is there interest in seeing this in postgres?
--
dave
---(end of broadcast)
