Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

2016-05-30 Thread David W Noon
the physical filesystems correctly and not damage them. - -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN PGP SIGNATUR

Re: [GENERAL] Deleting a table file does not raise an error when the table is touched afterwards, why?

2016-05-30 Thread David W Noon
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN PGP SIGNATURE- Version: GnuPG v2 iEYEARECAAYFAldMcjcACgkQogYgcI4W/5T/xgCfaQBh6g0WCBRkeNOlRK4Kbc43 Gs4An0UXb+piw+BQUGJupPtN+o

Re: [GENERAL] Tablespace limit feature

2014-11-04 Thread David W Noon
itself to limit the amount of disk space the tablespace can use. - -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN

Re: [GENERAL] EBCDIC conversion

2014-03-28 Thread David W Noon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/03/14 00:31, David W Noon wrote: I think the real issue is that you need icu or libiconv installed. You will also need to know which EBCDIC code page you want: U.S. EBCDIC is cp37, IIRC. I suspect you will need to write a C or Python

Re: [GENERAL] EBCDIC conversion

2014-03-27 Thread David W Noon
, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* david.w.n...@googlemail.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (GNU/Linux) Comment: Using GnuPG

Re: [GENERAL] Set returning functions in select column list

2012-02-17 Thread David W Noon
for or it is sparsely documented. The words to search for are Cartesian product. This is the way RDBMSes have handled unconstrained implicit joins since the days of SQL/DS. -- Regards, Dave [RLU #314465] == dwn...@ntlworld.com (David W

Re: [GENERAL] Set returning functions in select column list

2012-02-17 Thread David W Noon
(David W Noon) === -- 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] Let-bindings in SQL statements

2012-01-26 Thread David W Noon
I cannot be certain when now() was added, if ever; but I have been using CURRENT TIMESTAMP (space instead of vinculum) under DB2 for 20 years or more. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon

Re: [GENERAL] hash options

2012-01-22 Thread David W Noon
available to anybody who wants them. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* signature.asc Description: PGP signature

Re: [GENERAL] Duplicated Fields

2011-05-14 Thread David W Noon
...@ntlworld.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* signature.asc Description: PGP signature

Re: [GENERAL] Weird problems with C extension and bytea as input type

2011-03-22 Thread David W Noon
, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* signature.asc Description: PGP signature

Re: [GENERAL] Read binary records

2010-11-17 Thread David W Noon
be added to the contrib modules, if anybody is interested. The dwn_read_binary_file() function returns a bytea. If you want a private copy, contact me off-list. -- Regards, Dave [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* dwn...@ntlworld.com (David W Noon

Re: [GENERAL] What is return code for WAL send command

2010-10-25 Thread David W Noon
, it establishes all the most common environment variables before any cron job starts. - -- Regards, Dave [RLU #314465] == dwn...@ntlworld.com (David W Noon) == -BEGIN PGP

Re: [GENERAL] use of IN() with literals

2010-05-18 Thread David W Noon
(David W Noon) == signature.asc Description: PGP signature

Re: [GENERAL] Order of execution in shell echo to psql

2010-05-02 Thread David W Noon
5432 --username 'johngage' 'database_name' Try putting a semi-colon at the end of your SQL query. [Or try using proper copy-and-paste when writing your messages.] - -- Regards, Dave [RLU #314465] == dwn...@ntlworld.com (David W

Re: [GENERAL] regexp_replace puzzle

2010-03-10 Thread David W Noon
] === david.w.n...@ntlworld.com (David W Noon) === -- 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] continuous copy/update one table to another

2010-02-28 Thread David W Noon
AS t1 WHERE NOT EXISTS (SELECT * FROM table2 WHERE table2.key = t1.key); You will need to compare all fields in the key if it is a multi-column key. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon

Re: [GENERAL] Can the string literal syntax for function definitions please be dropped ?

2009-10-25 Thread David W Noon
a value, the single statement was almost invariably a RETURN with some query providing the value. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon

Re: [GENERAL] numeric field overflow

2009-10-06 Thread David W Noon
to the left and to the right of the decimal point. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon) === -- Sent via pgsql-general

Re: [GENERAL] UPDATE statement with syntax error doesn't raise a warning?

2009-09-25 Thread David W Noon
] === david.w.n...@ntlworld.com (David W Noon) === -- 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] where clauses and multiple tables

2009-09-09 Thread David W Noon
bar.name='martini'; The DISTINCT qualifier potentially changes the semantics, so the immediate answer is No. -- Regards, Dave [RLU #314465] === david.w.n...@ntlworld.com (David W Noon

Re: [GENERAL] where clauses and multiple tables

2009-09-08 Thread David W Noon
] === david.w.n...@ntlworld.com (David W Noon) === -- 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] Can SQL return a threaded-comment-view result set?

2003-10-03 Thread David W Noon
as well as demonstrates it. -- Regards, Dave [RLU#314465] == [EMAIL PROTECTED] (David W Noon) Remove spam trap to reply via e-mail. == ---(end of broadcast

Re: [GENERAL] move to usenet?

2003-08-20 Thread David W Noon
] == [EMAIL PROTECTED] (David W Noon) Remove spam trap to reply via e-mail. == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] move to usenet?

2003-08-20 Thread David W Noon
are rife all across Usenet. -- Regards, Dave [RLU#314465] == [EMAIL PROTECTED] (David W Noon) Remove spam trap to reply via e-mail. == ---(end of broadcast