Re: [GENERAL] Which SQL is the best for servers?

joel garry wrote: [...] > Check out Oracle XE [...] As far as I know, Oracle has never issued any patches for Oracle XE. Given the stream of patches for the "regular" Oracle database, I fear that an Oracle XE installation will have a number of known bugs - possibly security bugs. Or? (Note:

Re: [GENERAL] Reading from Mysql & writting in PGsql

On Sun, 27 Feb 2005 15:27:48 -0800, Mohsen Pahlevanzadeh wrote: > Dears,I need to read 1 field with select command from mysql.Then Write it > to pgsql. Which programming environment? Java/php/perl/c/...? -- Greetings from Troels Arvin, Copenhagen, Denmark ---(

Re: [GENERAL] When is a blank not a null or ''

ur work_email column, i.e. work_email values consisting of space(s). -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Dynamic SQL

ocs/8.0/static/ecpg-dynamic.html -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] How to overload POSITION

ectly on the dnaseq packed strings). (I will also try to create a specialized index for long strings, hopefully using some substring array algorithmics - but that's another story.) -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)-

[GENERAL] How to overload POSITION

ABLE STRICT; But now I get: ERROR: syntax error at or near "(" at character 36 LINE 1: CREATE OR REPLACE FUNCTION position(dnaseq,dnaseq) I assume this is because the POSITION function uses "IN" to separate arguments, in stead of a comma. Is there a way to overload it? -- Greeti

Re: [GENERAL] Trying to get postgres to use an index

you can make it permanent in postgresql.conf. -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] SQL norm views to describes tables (and probably some other things) of a database ?

in the documentation about that. PostgreSQL v. 7.4 introduced INFORMATION_SCHEMA, which is probably what you are looking for: http://www.postgresql.org/docs/7.4/static/information-schema.html -- Greetings from Troels Arvin, Copenhagen, Denmark

[GENERAL] RPM init-script: Why the locale setting?

I just ran into this). See http://www.postgresql.org/docs/faqs/FAQ.html#4.8 I suggest that the init-script be rewritten so that LANG and LC_ALL are unset before initdb is run (which happens the first time PostgreSQL is started after the RPM-based installation). -- Greetings from Troels Arvin,

Re: [GENERAL] LIMIT modifier

fier which PostgreSQL doesn't have. See also: http://troels.arvin.dk/db/rdbms/#select-limit -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings