Hi. I found this somewhere:
select a from b order by a using ~<~
I've been searching the docs but I found nothing about this weird ~<~
comparator. Not in comparison operators, String functions and operators,
nor the order by clause. Maybe it has something to do with regular
expressions, but s
Hi. I have a few databases created with UNICODE encoding, and I would
like to be able to search with accent insensitivity. There's something
in Oracle (NLS_COMP, NLS_SORT) and SQL Server (don't remember) to do
this, but I found nothing in PostgreSQL, just the 'to_ascii' function,
which AFAIK, d
Hi. I have PostgreSQL 7.4.8 installed on a SuSE Enterprise Server 9.
When I create a database, everything works fine until I restart the
computer. When I do that, and I try to connect to the database, I get
the following message;
psql: FATAL: database "mydb" does not exist
DETAIL: The databa
