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 ---(end

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

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

-- 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])

[GENERAL] How to overload POSITION

( 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? -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end

Re: [GENERAL] How to overload POSITION

). (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)--- TIP 1: subscribe

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

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 ?

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 ---(end of broadcast

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

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, Copenhagen

Re: [GENERAL] LIMIT modifier

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