[SQL] How to use BYTEA type?

):- chris=# insert into fax_info ( comment, image ) values ( 'Faking it with a computer', byteain ('picture.pgm.gz')); INSERT 18772 1 Is this correct? Now, how do I get my picture out again? TNX 10^6 Sincerely etc. Christopher Sawtell.

Re: [SQL] Restricting access to Large objects

On Tue, 16 Oct 2001 03:46, Tom Lane wrote: > "Aasmund Midttun Godal" <[EMAIL PROTECTED]> writes: > > How can I restrict access to large objects. > > You can't. This is one of the many deficiencies of large objects. But now that the limit on row length / size has gone away, and that the new BYTE

Re: [SQL] select 5/2???

On Mon, 08 Oct 2001 22:31, BELLON Michel wrote: Works ok for me. chris=# select -5/2.0; ?column? -- -2.5 (1 row) chris=# select version(); version - PostgreSQL 7.1.1 on i586-pc-linux-gnu, compi

Re: [SQL]

On Thu, 04 Oct 2001 01:55, postgresql wrote: > Please can someone help > > I tried to subccribe to pgsl-admin but I have been unable. > > I just upgraded to Mac osx 10.1. When I try to configure --with-tcl I get > an error that 'wish' can not be found. Where do I get this? (this is not so > i

Re: [SQL] Number the lines

On 17 Sep 2001 14:54:51 +0200, Kovacs Baldvin wrote: > Hi! > > I am in the university now, not be able to test what I > say, so please forgive me if it is buggy or wrong. > > So does it helps you?: That works correctly. Thanks very much for the tip . Do not forget to DROP the sequence afterwar

Re: [SQL] Execute permsissions on fuctions

On Sat, 25 Aug 2001 16:42, Zot O'Connor wrote: > Christopher Sawtell wrote: > > On Fri, 24 Aug 2001 06:52, Zot O'Connor wrote: > > > Other SQL servers have the concept of stored procedures having > > > different permissions. > > > > >

Re: [SQL] Array in plpgsql

On Mon, 20 Aug 2001 08:41, omid omoomi wrote: > hi all, > Can some body show me how to declare a variable of type "array" in a > function using plpgsql ? http://www.postgresql.org/idocs/index.php?non-atomic-values.html#AEN1244 -- Sincerely etc., NAME Christopher Sawt

Re: [SQL] Arithmetic operation on DATE

On Mon, 13 Aug 2001 21:38, macky wrote: > is it possible to add a date datatype column to a number resulting to a > date.. chris=# select date(date(CURRENT_TIMESTAMP) + '6 @months'::interval); date 2002-02-13 (1 row) More of what you want? > theoretically it should do this

Re: [SQL] Arithmetic operation on DATE

On Mon, 13 Aug 2001 21:48, macky wrote: > is it possible to add a date datatype column to a number resulting to a > date.. chris=# select date(CURRENT_TIMESTAMP); date 2001-08-13 (1 row) chris=# select date(CURRENT_TIMESTAMP) + '6 @days'::interval; ?column? ---

Re: [SQL] Fuzzy matching?

On Wed, 01 Aug 2001 05:44, Tom Lane wrote: > "Josh Berkus" <[EMAIL PROTECTED]> writes: > > For many of my programs, it would be extremely useful to have some form > > of "fuzzy matching" for VARCHAR fields. There are two kinds of fuzzy > > matching for words that I know of: > > > > 1. Phonetic ma

Re: [SQL] Date Validation?

est for dates being in the past, and that it would be better if the error message was delivered in a pop-up html page or a JavaScript alert. Off the top of my head another untested idea for a solution to the problem is to do the data verification in JavaScript on the client machine. There is

Re: [SQL] day difference

PostgreSQL 7.1.1 on i586-pc-linux-gnu, compiled by GCC 2.95.3 (1 row) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz --&g

Re: [SQL] Need help with search-and-replace

uses the tab character as the delimiter by default. single line file attached -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Ple

Re: [SQL] '13 months ago'::reltime

On Friday 04 May 2001 06:32, you wrote: > Type reltime is old and deprecated. Don't use it. What should we be using instead? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.

Re: [SQL] Re: psql win32 version

?q=ipgsql-1.6.2.zip%A0&btnG=Google+Search -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML

Re: [SQL] Re: psql win32 version

y getting the file via an anonimizer. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WO

Re: [SQL] Re: psql win32 version

This one worked a minute ago:- http://www.zeos.dn.ua/download/ipgsql-1.6.2.zip On Thu, 15 Mar 2001 14:14, datactrl wrote: > The URL shown below can not get through. Would you please check again. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ

Re: [SQL] my pgsql error?

On Wed, 14 Mar 2001 01:38, Richard Huxton wrote: > From: "Christopher Sawtell" <[EMAIL PROTECTED]> > > > Please could a kind soul help me with this. [ ... ] > Note to readers: this is not a general service, I'm in a good mood ;-) In that case, thank you ver

[SQL] my pgsql error?

. chris=# select nice_date(date('today')); NOTICE: plpgsql: ERROR during compile of nice_date near line 12 ERROR: parse error at or near "return" Please, what am I doing wrong? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL

Re: [SQL] from PosgreSQL 7.1b3 to 7.0.3

orward to either the beta5 release or to use the current cvs. There have been big and good changes between 7.0.x and 7.1. If you wait just a few ( approximately 10 ) days 7.1 will released as a public release. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451

[SQL] Buglet?

isng the field[n]=x notation. ) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML o

Re: [SQL] count number of weeks??

it will work in 7.0.3, but upgrading is just a doddle. PostgreSQL compiles faultlessly. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/langu

Re: [SQL] Array as parameter in plpgSQL functions

CREATE chris=# select array_element_count('{59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,8 7}'); array_element_count - 29 (1 row)

Re: [SQL] conversion

On Mon, 26 Feb 2001 17:11, Ken Kline wrote: > follow up > actually the destination column is defined > as a numeric(4) Could you to a \d on each of the tables and tell us the results. [ ... ] -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN

Re: [SQL] logging a psql script

ore" or "less". man script for the details. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrai

[SQL] Bug? Me or PostgreSQL.

) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--

Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?

On Thu, 08 Feb 2001 05:38, Brice Ruth wrote: > Is there a simple (unix) command I can run on text files to convert > cr/lf to lf? The way I did it seemed pretty ass-backward to me (not to > mention time consuming). This little heiroglyph will convert all text files rescued from that man's syste

Re: [SQL] how to do plpgsql?

db program. Strikes me that this should be available by default as part of the installed product. On the other hand I might be missing something, if so I'd like to be informed. Thanks. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL

Re: [SQL] Postgres-HOWTO

of very good information in there buried underneath the ... um ... -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Pleas

Re: [SQL] binary operators

On Wed, 31 Jan 2001 04:12, Frederic Metoz wrote: > Hello, > > I am looking for the binary AND and OR ... SHIFT as well. > Do they exist for postgresql ? AND and OR . yes. SHIFT I don't think so. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021

Re: [SQL] Automated scripting...

his possible with SQL? My understanding is that it is not > possible but thought I'd ask anyway. I know it seems a bit messy, but you could always use a temporary table to store the values. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL

[SQL] Is this feature a bug?

e. How can I turn it off? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--

Re: [SQL] Re: Problem with Dates

day 5 | Friday 6 | Saturday (7 rows) school=# select name from day where number= \ (select date_part('dow','now'::datetime) as day); name Sunday (1 row) Correct!! The PostgreSQL Team is to be congratulated. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--

Re: [SQL] Re: Problem with Dates

in the mail archives about 6 to 9 months ago iirc. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refr

Re: [SQL] Re: Problem with Dates

t; (1 row) [ ... ] I get the same result. This business of crooked dates in NZ summertime is frequently because the rest of the world can't twig on to the notion that it is possible to have GMT + 13, and do not take account of it in date/time calculations. -- Sincerely etc., NAME

Re: [SQL] SQL Query Results

t for the full details. have fun. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -->> Please refrain from using HTML or WORD attachments in e-mails to me <<--

Re: [SQL] PostgreSQL HOWTO

WTO document is distincly unbalanced, but if you have the time to filter out all the raving lunacy there is quite an informative work hidden away in there. I'd agree that this HOWTO need editorial work, but please note that it is not an official PostgreSQL offering. -- Sincerely etc., NA

Re: [SQL] Don't understand creation statement's answer

On Mon, 18 Dec 2000 12:32, Thomas SMETS wrote: > Hi, > > In the long term I'm willing to construct a Little Java application that > runs a library. you might find http://www.koha.org interesting Library management on all free software. -- Sincerely etc., NAME Christop

Re: [SQL] pg_hba.conf

u have copied pg_hba.conf.sample to pg_hba.conf havn't you? If that dosn't work check the permissions. The file has to readable by the pgsql server/backend. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra

Re: [SQL] Tutorial

rry I do not know of any in Italian, but this Google query might produce something for you:- ( set the search language to Italian before searching. ) http://www.google.com/search?q=Italian+SQL+Tutor&btnG=Google+Search -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 I

[SQL] Tuple size limit.

ow if this 7.1 release is imminent; i.e. < ~2 to 3 months? I am right in thinking that one cannot do textual searches on BLOBs aren't' I? TNX 10^6 -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 - Text message enabled - http://www.mtnsms.com ICQ UIN

Re: [SQL] New book on Postgres

atement that you agree to non-disclosure of it and I > will send you more information. How are you getting on with this? Havn't heard from you for a while? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co

Re: [SQL] Merging two columns into one

e copy command, remove the delimiter with the unix command 'tr -d' import the file, now minus the delimeter using the copy command. -- Sincerely etc., NAME Christopher Sawtell - iOpen Technologies Ltd. CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL chris @ iopen . co . n

Re: [SQL] \copy...

sing delimiters '|'; see sql-copy.htm in online doco. -- Sincerely etc., NAME Christopher Sawtell - iOpen Technologies Ltd. CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL chris @ iopen . co . nz, csawtell @ xtra . co . nz WWWhttp://www.iopen.co.nz CNOTES ftp://f

Re: [SQL] moving DB

atever way is appropriate. psql -e template1 < db.out # on PC2 -- Sincerely etc., NAME Christopher Sawtell - iOpen Technologies Ltd. CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL chris @ iopen . co . nz, csawtell @ xtra . co . nz WWWhttp://www.iopen.co.nz CNOTES