I'm working with a closed source application that reads an ASCII file
and as it does it (via ODBC) creates tables and indexes, inserting as it
goes. Like so:
CREATE TABLE bgsuser.CAXCTRLD ( CTRLS INTEGER, INTVL INTEGER);
CREATE UNIQUE INDEX bgsuser.PRIMARY_CAXCTRLD ON bgsuser.CAXCTRLD
(CTRLS,IN
But after looking closely at the list of a possible properties, i found
out that some of them depend on others. For example, if item is a
PDF document, it can have an index. But a document can also have an
index with links. Logically, a properties like 'index with links'
don't belong to the verific
select replace( replace( replace( replace( 'Test ä ö ü ß', 'ä','ae'),
'ö','oe' ), 'ü','ue'), 'ß','ss' );
Thanks a lot. A wrote this into a user defined function with lower()
around the source string, and it works. :-)
CREATE OR REPLACE FUNCTION public.unumlaut(varchar)
RETURNS varchar AS
'sele
I want to query words with German "umlauts" (special characters) with
and without normalization. I want to find "grün" (green) written
"gruen" as well.
Using "LIKE" with locale de_DE.iso88591 or .utf-8 does not help (Locale
support should affect "LIKE",
http://www.postgresql.org/docs/7.3/static/ch
Is there anyway we can track queries entered?
Is there a table that stores all the actions that a user entered? (history)
Is there such a feature?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
I have a query that returns
?column?
-
6 days 01:56:14
(1 row)
How can I get it as total number of hours?
Instead of days and hours, I need hours only (all in all, so 24hours * 6
days + 01:56:14)
Can you help me please? Thanks
---(end of bro
What's the best open source GUI for DB administration? (postgres)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
