Hi Karsten,
modifying user inputted data is not an option for me. I need to maintain the
original data. I had read about indexing on a lower function. This all seems a
bit of a bodgy workaround to me. A clean Case Insensitive collation setting is
cleaner. Is this supported in postgreSQL 9?
R
Thanks Pavel,
Is this the only way?. I would prefer to use a collation setting if this is
possible. Do you know whether there would be a performance hit using non
standard character strings?
Phillip
osts regarding using LOWER function
for querying. This is a workaround for point (2) but does not remedy point (1)
above.
Many thanks
Phillip
Phillip Smith
On 6 August 2010 16:08, Torsten Zühlsdorff wrote:
>
> I receive my "oh wow" when i do the same things in Postgres like in MySQL:
> Writting some procedures, triggers and use foreign key. The "oh wow" was
> that it just *works*. After some years of using MySQL this is a very
> uncommon feeling, ev
On 5 August 2010 11:54, andi astowo wrote:
>
> At this oppurtinity we ask for your support to give us informations regarding
> the bellow questionaires. First, how can we have our data of the Postgre 7
> under Red Hat Linux 7.2 to be used by the Postgre 8 under RHEL 5?. Secondly,
> if above con
> We have a center in Europe who has just started to use PostgreSQL and was
> asking me if there are any Symantec product or other products that backup
> this type of database.
It doesn't appear to. I've just been through the whole rigmarole of
BackupExec for some Windows Servers, and I couldn't f
Where are you trying to execute these commands? They should be run at
the command line as they are 'standalone' programs, not SQL commands to
be run in an SQL session.
On Mon, 2007-05-07 at 10:01 +0100, kannan kk wrote:
> hello
>
> when i try to execute createdb,psql,pg_dump,pg_restore and simil
