Re: [GENERAL] no pg_hba.conf entry for replication connection

e is that I followed Did you reload the configuration after changing pg_hba.conf, e.g. "SELECT pg_reload_conf()"? Also, looks like you have a typo: > host replication repuser 127.0.0.1/32 mds5 > host replication repuser 0.0.0.0/0 mds5 mds5 -> md5

Re: [GENERAL] cluster question

"pg_ctl_options" to something like: pg_ctl_options='-l /path/to/log' Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Extract date from a TIMESTAMP(6) WITHOUT TIME ZONE NOT NULL column

that date into two columns on my select: > > 2015-12-18 = date column > 02:40:00 = time column > > How can I do that without modifying any column/data? > Maybe in a select? TO_CHAR() is your friend: https://www.postgresql.org/docs/current/static/functions-formatting.html Regards Ia

Re: [GENERAL] Streaming Replica Master-Salve Config.

ich is what I guess you mean with "shared_memory") can be a different value appropriate to the standby's hardware resources. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services -- Sent v

Re: [GENERAL] upgrade to repmgr3

had this particular use-case before, so I'll add some notes to the documentation on how best to handle it. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (p

Re: [GENERAL] pg_archivecleanup - Increase time files are deleted

WAL to retain, though you do then need to be careful that all standbys are actually consuming WAL otherwise files will be retained for ever (or until disk space runs out, whichever comes first). Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Dev

Re: [GENERAL] backup and archive postgresql data older than 6 months

we have only six months of postgresql data on the postgresql database server. Have you looked at Barman ( http://www.pgbarman.org/ )? Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training Services

Re: [GENERAL] Postgresql BDR Replication Setup Issue

(...) == Data from Node2 log file 2015-06-08 10:08:45.957 PDT LOG: entering standby mode It looks like you're trying to run BDR on a streaming replication standby. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA

Re: [GENERAL] phppgadmin : login failed

: -- Looks like you're missing an entry for IPv6 in pg_hba.conf; something like this: hostall all ::1/128 md5 Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: [GENERAL] Enum in foreign table: error and correct way to handle.

the IMPORT FOREIGN SCHEMA command, however this is limited to table/view definitions. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] schema or database

a variable number) and will make life easier if you ever need to do some kind of query involving multiple customers. There will also be less overhead when adding a new schema vs adding a new database. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL

Re: [GENERAL] unrecognized configuration parameter bdr.connections

, particularly: http://bdr-project.org/docs/0.9/release-0.9.0.html http://bdr-project.org/docs/0.9.0/quickstart-editing.html http://bdr-project.org/docs/0.9.0/quickstart-enabling.html Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: [GENERAL] Pattern matching ints

ms (7 rows) [1] http://www.postgresql.org/docs/current/interactive/pgtrgm.html Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] PG user group in the Kuala Lumpur area?

but kind of from Germany, now in Japan). Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, RemoteDBA, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] psql connection issue

the CGI scripts use is expecting to find the socket in another directory, e.g. /var/run/postgresql/. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] installing on mac air development machine

for 9.4 beta 3 yet ? we would use that if available and not too hard to install beta3 has not yet been released (October 9th is the scheduled date). Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [GENERAL] UPDATE table: Syntax to Remove Terminal '\n'

) should do the trick: postgres= \pset linestyle unicode Line style (linestyle) is unicode. postgres= SELECT E'foo\n'; ?column? ── foo ↵ (1 row) Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: [GENERAL] UPDATE table: Syntax to Remove Terminal '\n'

On 14/08/28 8:04, Ian Barwick wrote: On 14/08/28 7:31, Rich Shepard wrote: I have some rows in a table where a column attribute has a newline (\n) appended to the string. How do I represent that newline character in a SQL statement using psql? I've tried adding E'\n' to the end

Re: [GENERAL] SELECT 'NOW()' - OK, SELECT 'CLOCK_TIMESTAMP()' - ERROR

the special literal value 'now' to specify the current date and time and also here: http://www.postgresql.org/docs/9.3/static/datatype-datetime.html#AEN5861 Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training

Re: [GENERAL] Appended '+' in Column Value

'; Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Global value/global variable?

)) Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml

if there was something else I needed to do. Was the database server restarted after the new version was built? Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL using --with-libxml

; in particular you should always run the latest minor version, which is currently 9.2.8. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: Fwd: [GENERAL] How to ignore blank lines with file_fdw

force_not_null can do the trick since that is on the column level and not lines/row. The blank lines referred to here are in the source code itself. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent

Re: [GENERAL] A note on pg_upgrade and missing pg_upgrade_support.so

2010/9/21 Bruce Momjian br...@momjian.us: Bruce Momjian wrote: Ian Barwick wrote: Hi Just a quick note for anyone else building 9.0 from source and experimenting with pg_upgrade - if you get a message like the following when running the pg_upgrade binary: pg_upgrade_support.so

[GENERAL] A note on pg_upgrade and missing pg_upgrade_support.so

ago, see: http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_upgrade/Attic/pg_upgrade ) HTH Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] MySQL versus Postgres

results quickly with Postgres. Bruce Momjian's book is an excellent primer: http://www.postgresql.org/docs/books/awbook.html It is *very* outdated (I remember using that to get started myself, almost 10 years ago) and a lot has been improved since then. Ian Barwick -- Sent via pgsql-general

Re: [GENERAL] sql dump

. Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [offtopic] How do you name a table...

2010/4/8 Ognjen Blagojevic ogn...@etf.bg.ac.rs: Hi, How do you name a table which sole purpose is to store a list of values? (...) Is this: a. Lookup table b. Classifier c. Cypher(er)? I'm looking for the appropriate term in English. I'd call it a lookup-table. Ian Barwick -- Sent

Re: [GENERAL] Unexpected result from selecting an aliased but non-existing column called name

Hi Adrian, 2010/3/9 Adrian Klaver adrian.kla...@gmail.com: On Tuesday 09 March 2010 12:50:45 am Ian Barwick wrote: Hi I was wondering where some spurious information in a query was coming from - it looked like something was inserting all the values of a table row as a comma-separated list

[GENERAL] Unexpected result from selecting an aliased but non-existing column called name

on 8.4.1 and 8.4.2; does not work in 8.3.1 (old test version I happen to have hanging around). Questions: - is this a feature? - and if so, where is it documented? (given that the key word in this is name, this is a tricky one to research). Thanks for any pointers. Ian Barwick -- Sent via

Re: [GENERAL] PostgreSQL Conference 2009 Japan

I'm not sure whether I'll be able to attend all of the conference I will certainly be around and it would be great to meet up. Also, if anyone needs any help / advice / translation etc., feel free to ask and I will do my best. Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Converting Rows to Columns

--+--++-- 101 | COLON, CRISTOBOL | OPEZ, CARLOS | 102 | COLON, CRISTOBOL | LUGO, FERNANDO | (2 rows) (No doubt there are probably more elegant ways of doing this) HTH Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Noob Q: Is the PG database its own source code backup?

these; and a file which contains the SQL required to make the changes between application releases. Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Smartest way to resize a column?

) HTH Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Howto return values from a function

actionlist line 11 at return next You probably need to do SELECT * FROM actionlist(123) Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] tsearch2 best practices

2007/11/18, Mag Gam [EMAIL PROTECTED]: Hi All, Planning to implement tsearch2 for my websitem and dbschema. I wanted to know if there is a Best practices guide I should be following. While reading about it, I noticed there were lot of 'gotchas' with this, such as back-up/restore, Slony 1

Re: [GENERAL] IP addresses

of doing it (didn't see any, but..) You want the network address functions and operators, I presume: http://www.postgresql.org/docs/8.2/interactive/functions-net.html HTH Ian Barwick -- http://sql-info.de/index.html ---(end of broadcast)--- TIP

Re: [GENERAL] stripping HTML, SQL injections ...

validation for security-related operations ;). Regards Ian Barwick -- http://sql-info.de/index.html ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Upper and Lower-cased Database names?

connected to. If you do \c MyTest mytest=# select * from MyTest.public.cars; the query will work (case is not the problem here). HTH Ian Barwick -- http://sql-info.de/index.html ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [GENERAL] Why is default value not working on insert?

to the intended default value). Ian Barwick ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] PostgreSQL Server Crash using plPHP or PL/Perl

. I've seen this kind of error in connection with hardware errors (typically bad RAM or severe hard disk errors). Have you attempted replicating this problem on another system to confirm / exclude this as a possible cause? Ian Barwick -- http://sql-info.de/index.html

Re: [GENERAL] MediaWiki and Postgresql?

believe it's called pgpedia. That'd be wikipgedia: http://pgfoundry.org/projects/wikipedia/ Ian Barwick ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] MediaWiki and Postgresql?

functions, * than MySQL ones, some of them should be moved to parent * Database class. * * STATUS: Working PG implementation of MediaWiki * TODO: Installer support * * @package MediaWiki */ (There's also includes/DatabaseOracle.php but it doesn't say anything about status). Ian Barwick

Re: [GENERAL] PostgreSQL Gotchas

of the MySQL gotchas list, I created one for PostgreSQL for the sake of balance. Though I'm really having to scrape the barrel for material ;-). The MySQL list is a little outdated; I'm going through it with updates for version 5. Ian Barwick ---(end of broadcast

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

/index.html Oracle acquires Innobase, which is the company behind the InnoDB table bit of MySQL, i.e. the engine with the foreign keys, transactions and all that. Is there a shortage of lion toothpaste in Sweden or something? Ian Barwick ---(end of broadcast

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

had a chance to update the site much recently, but I'm slowly going through the list to update it for MySQL 5. Ian Barwick ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Hash problem

is longer than the database field etc.) and this is causing the insertion of invalid values in the above statement. Ian Barwick ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

Re: [GENERAL] PostgreSQL still for Linux only?

: http://firebird.sourceforge.net/index.php?op=historyid=ann_2 (This page: http://firebird.sourceforge.net/index.php?op=historyid=ann_1 says also: InterBase started in the shower. Maybe the something else that escapes me was NetBSD? ;-) Ian Barwick ---(end of broadcast

Re: [GENERAL] SCHEMA compatibility with Oracle/DB2/Firebird

providing schema names for your common functions, e.g. SELECT * FROM common.mytable . Depending on your app, that could be better from a security point of view in PostgreSQL as well, if you want to prevent your users from sneakily replacing the common database objects. Ian Barwick

Re: [GENERAL] Oracle and Postgresql Play Nice Together on Same Computer?

, MySQL, DB2 and Oracle on the same development machine without any issues. Of course if another application is in constant use on a production server PostgreSQL won't perform as well as it could. Ian Barwick ---(end of broadcast)--- TIP 5: Have you

Re: [GENERAL] How to manually insert an UTF-8 character into an SQL statement?

('C'||encode(decode('c3b4','hex'),'escape')||'te d''Azur'); Ian Barwick ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [GENERAL] PG8 final when

/2004-12/msg9.php ): ... The current plan is to make final release around December 15th if everything goes well. ... Ian Barwick ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] pl/pgsql oddity

as ' declare l integer; begin l = 38; if l 38 then return '' 38''; elseif l = 38 then Try elsif here. (No, I don't know what the problem with elseif is). Ian Barwick ---(end of broadcast)--- TIP 9: the planner will ignore your

Re: [GENERAL] Oid to text...

or something like that? Are these mappings stored anyware? pg_catalog.pg_type ? Ian Barwick ---(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] Help with syntax for timestamp addition

WHERE date + (numdays || ' days')::interval = CURRENT_TIMESTAMP; Ian Barwick ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [GENERAL] Transactions in different DB

, it's possible to do a single transaction on two different databases ?? Not AFAIK, though contrib/dblink might be able to help you. HTH Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [GENERAL] Max length name of a database/schema

/postgres_ext.h and look for NAMEDATALEN. Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Calling on all SQL guru's

' Caveats: - this is _not_ schema-aware. - requires the information schema, e.g. 7.4 and later - might just be horribly wrong anyway, but you get the general idea ;-) HTH Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe

Re: [GENERAL] counting records of schema

summe; END;$BODY$ LANGUAGE 'plpgsql' VOLATILE; BTW you don't need to specify VOLATILE here - it's the default - and STABLE might be the appropriate choice anyway. HTH Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you

Re: [GENERAL] having clause question

, it errors out ERROR: column c does not exist Is it possible to do a query like this with PostgreSQL? select lastname,count(*) as c from names group by lastname having count(*) 1; HTH Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP

Re: [GENERAL] compatibilityissues from 7.1 to 7.4

apps); also, the LIMIT x,y syntax will no longer work. Your best bet is fro someone who knows your system to go through the PostgreSQL release notes. Ian Barwick ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index

Re: [GENERAL] unicode and varchar

the 7.4.x database have? Ian Barwick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Confused with db client encoding

- müller (1 row) ctest=# SET client_encoding TO UNICODE; SET ctest=# SELECT * FROM coding; data - müller (1 row) Ian Barwick ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] UTF-8 and LIKE vs =

On Tue, 24 Aug 2004 00:46:50 +0200, Markus Bertheau [EMAIL PROTECTED] wrote: , 23.08.2004, 23:04, David Wheeler : On Aug 23, 2004, at 1:58 PM, Ian Barwick wrote: er, the characters in name don't seem to match the characters in the query - '' vs. '' - does that have any bearing

Re: [GENERAL] UTF-8 and LIKE vs =

On Mon, 23 Aug 2004 16:50:04 -0700, David Wheeler [EMAIL PROTECTED] wrote: On Aug 23, 2004, at 4:34 PM, Ian Barwick wrote: wild speculation in need of a Korean speaker, but: [EMAIL PROTECTED]:~/tmp cat j.txt [EMAIL PROTECTED]:~/tmp uniq j.txt All

Re: [GENERAL] estimating table size

judgements about averages for varchar columns. The hidden storage overhead is what I'm wondering about, I guess. There is a little info in the FAQ: http://www.postgresql.org/docs/faqs/FAQ.html particularly sections 4.6 and 4.14 Ian Barwick [EMAIL PROTECTED] ---(end

Re: [GENERAL] nmap not showing postgres

On Sun, 18 Jul 2004 15:30:01 +0200, Ian Barwick [EMAIL PROTECTED] wrote: On Tue, 13 Jul 2004 05:53:36 +0100 (BST), raj veluchamy [EMAIL PROTECTED] wrote: hello all, i am running postgres in compiling postgres in OSCAR cluster. installation is done to /home/pgsql as i couldn't do

Re: [GENERAL] Pg + perl + apache

for a selectrow_array, or one of those others mentioned? Just checking, but do all your scripts have : use strict; use warnings; at the top? Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [GENERAL] Buglist

( id INT unique, info text ) type=innodb; create table abc1234 ( moreinfo text, ref_id int REFERENCES abc123(id) ) type=innodb; but the foreign key defined on ref_id is (I presume) transported to a remote forest in Sweden and eaten by goats ;-) Ian Barwick [EMAIL PROTECTED

Re: [GENERAL] Why lower's not accept an AS declaration ?

' between t.begin and t.end then t.login else 'None' end as log, LOWER(case when 'now' between t.begin and t.end then t.login else 'None' end) as log_lower from my_table t order by 2; Ian Barwick [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] Auto completion in psql

completion. The person that manages the machine installed from sources. It needs to be (re)compiled with readline support, and you will need the readline headers (SuSE provides a readline-devel rpm). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast

Re: [GENERAL] migrating data from 7.3.x down to 7.2.x

On Tuesday 15 July 2003 09:51, Stefan Armbruster wrote: Hi, Am Mon, 2003-07-14 um 21.01 schrieb Ian Barwick: On Monday 14 July 2003 16:04, Stefan Armbruster wrote: Hi, I tried to migrate a database from 7.3.2 down to PostgreSQL 7.2.2 Any particular reason? Yes, I'm developing

Re: [GENERAL] Firebird vrs Postgresql

, or possibly GNU/Unixen ? ;-) Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

Re: [GENERAL] Accent insensitive search

%'; brings both results instead of only showing Polo. One solution[*]: SELECT * FROM testtable WHERE to_ascii(testfield,'LATIN1') LIKE '%olo%' Note this might not work with all database encodings, especially UNICODE. [*] no doubt someone will be along in a moment with another. Ian Barwick [EMAIL

Re: [GENERAL] Duplicate key insert question

On Wednesday 02 July 2003 02:58, Jean-Christian Imbeault wrote: (B Alvaro Herrera wrote: (B No, only the "second" one will fail (though it's difficult which one is (B the second) (B (B From: (B (B http://marc.theaimsgroup.com/?l=postgresql-generalm=105656988915991w=2 (B (B I

Re: [GENERAL] adding fields to a table

whatever http://www.postgresql.org/docs/view.php?version=7.3idoc=0file=ddl-alter.html IIRC it was introduced fairly recently (7.3?) Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [GENERAL] timestamp() broken in 7.2.4?

://www.postgresql.org/docs/view.php?version=7.3idoc=0file=release-7-2.html The timestamp(), time(), and interval() functions are no longer available. Instead of timestamp(), use timestamp 'string' or CAST. - something like: select timestamp '2001-01-01 00:00'; should work Ian Barwick [EMAIL PROTECTED

Re: [GENERAL] INSERT WHERE NOT EXISTS

dummy_table bit. (in Oracle it would be FROM dual). Ian Barwick [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] INSERT WHERE NOT EXISTS

On Wednesday 25 June 2003 21:37, Mike Mascari wrote: Ian Barwick wrote: On Wednesday 25 June 2003 20:06, Reuben D. Budiardja wrote: (...) This kind of query should work; just leave out the FROM dummy_table bit. (in Oracle it would be FROM dual). I proposed that same solution 3 years ago

Re: [GENERAL] query help

AND xref.function_id=? - and here (disclaimer: statement untested) The values not available will be returned as NULL. Thanks a bunch, a bunch of what? ;-) HTH Ian Barwick -- Ian Barwick - Developer http://www.akademie.de Remove SUNGLASSES to reply ;-) ---(end