Re: [SQL] how do i provide array parameters for my functions in php

;)"; Now if your function outputs an array, thats a little bit more complicated lies in the php field and you need to ask pgsql-php or something like that. > > what is the right syntax > TIA > joseph > > ---(end of broadcast)----

Re: [SQL] function text_ge(text, text), how to use on version 7.2

--(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel:+30-10-8981112 fax:+30-10-8981877 emai

Re: [SQL] text vs varchar

enable_indexscan = off; SET VARIABLE dynacom=# EXPLAIN ANALYZE SELECT subject from repdat where subject='UTM FOR SPECIAL SURVEY JUNE2000'; NOTICE: QUERY PLAN: Seq Scan on repdat (cost=0.00..388.59 rows=1 width=28) (actual time=0.03..8.14 rows=1 loops=1) Total runtime: 8.19 msec EXPL

Re: [SQL] Aggregates not allowed in WHERE clause?

y to get what I want? SELECT lv.kvvnr,lv.semester from lv where lv.semester = (select max(semester) from lf_sem); > > Clueless, > joachim > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send

Re: [SQL] date_ge and time_ge

_ > > PFISTER + PARTNER, SYSTEM - ENGINEERING AG > Juerg Rietmann > Grundstrasse 22a > 6343 Rotkreuz > Switzerland > > internet : www.pup.ch > phone : +4141 790 4040 > fax : +4141 790 2545 > mobile: +4179 211 0315 &

Re: [SQL] CASE Select, referring to selected value

error at or near ">" > > Does anyone know how I could accomplish this? > > Thanks in Advance! > Nick > > > > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an

Re: [SQL] pg_restore cannot restore function

In the case that you moved your backup to another system where possibly the shared library (.so) where the function exists is on a different location then thats the problem, in which case you only need to recreate the function (with the same isstrict,iscachable attributes). -- Achilleus

Re: [SQL] Why doesn't it use indexes?

) >-> Sort (cost=775.05..775.05 rows=6629 width=328) > -> Seq Scan on apartment_reo reo (cost=0.00..354.29 rows=6629 > width=328) >-> Sort (cost=566.69..566.69 rows=4521 width=133) > -> Seq Scan on USER usr (cost=0.00..292.21 rows=4521

Re: [SQL] how to write procedures

earched our list archives? > > http://archives.postgresql.org > > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of broadcast)-

Re: [SQL] how to write procedures

; > > > ---(end of broadcast)--- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel:+30-10-8981112 fax:

Re: [SQL] newbie question

; > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel:+30-10-8981112 fax:

Re: [SQL] export plpgsql function to file

ion to a file? > > > > > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > > -- Achilleus Mantzios S/W Engineer IT dept Dyn

Re: [SQL] Error with DISTINCT and AS keywords

from tTitel; > > > > Greetings, > Andreas > > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Achilleus Mantzios S/W Engin

Re: [SQL] list of tables ?

gt; is there an easier way t get a list of tables ? > > i'm on 7.2 select * from pg_tables; > > ta, > > Steve Brett > > > > ---(end of broadcast)------- > TIP 4: Don't 'kill -9' the postmast

Re: [SQL] A SQL Training

> Now, we do not know how many children are in the list. How could we list > this family tree in "tree" formt by only using SQL? > > Best regards. > > > > > > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:

Re: [SQL] How to find out if an index is unique?

a given index was created > with the unique qualification? I don't want to insert data to try. > > Greetings, > > Dirk > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://arch

[SQL] pg_dump and sequences

oo2" FROM stdin; \. -- -- TOC Entry ID 5 (OID 2009762) -- -- Name: "foo2_id_key" Type: INDEX Owner: postgres -- CREATE UNIQUE INDEX foo2_id_key ON foo2 USING btree (id); -- -- TOC Entry ID 3 (OID 2009757) -- -- Name: foo2_id_seq Type: SEQUENCE SET Owner: postgres -- SELECT setval (

Re: [SQL] pg_dump and sequences

On Tue, 23 Jul 2002, Achilleus Mantzios wrote: Just a correction > Hi, i am using postgreSQL 7.2.1 on a redhat 7.2 (kernel > 2.4.9-31,glibc-2.2.4-24). > > It seems that pg_dump -t "tablename" dumps correctly the sequence of a > table's column,when

Re: [SQL] pg_dump and sequences

On Wed, 24 Jul 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > >> It seems that pg_dump -t "tablename" dumps correctly the sequence of a > >> table's column,when the column is named after "id". > > > I meant

Re: [SQL] 3-tier

oadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [E

Re: [SQL] expressions operating on arrays

look at /usr/local/src/postgresql-7.2.1/contrib/intarray -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of

Re: [SQL] [GENERAL] arrays

ring of polynomial formulae of arbitary degree checkout the intarray package in contrib for further info. I think pgsql arrays provide a natural solution to certain problems where it fits. ====== Achilleus Mantzios S/W Engineer IT de

Re: [SQL] [GENERAL] arrays

! == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have

Re: [SQL] Formatting current_time output

SELECT to_char(now(), 'HH24:MI AM'); (in 7.2.1) == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL

Re: [SQL] epoch to date

Software & GNU/Linux Club - http://fslc.usu.edu/ + > All in all, you're just another brick on the wall... > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster >

Re: [SQL] Can Postgres cache a table in memory?

> > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > == Achilleus Ma

Re: [SQL] rows in order

the path to the parent (pure sql), or arrays) - The contrib/tree implementation == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email

Re: [SQL] Viewing stored procedure code

New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > == A

Re: [SQL] SQL Error

ybe hpux runs on a 64-bit architecture processor == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EM

Re: [SQL] triggers

to the Postgresql > backend. > > - Richard Huxton Yet another cool feature (ala java listeners) of postgresql. P.S. Is the word "thank you" too difficult to be written by people posting and reading?? If anything else, a "thank you" is a motive. =======

Re: Fwd: Re: [SQL] Can I search for an array in csf?

t; > > >---(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 to the mailing list cleanly

Re: Fwd: Re: [SQL] Can I search for an array in csf?

broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610

Re: [SQL] Locking that will delayed a SELECT

ad of select. That way T2's queries will wait untill T1's statements commit or rollback. The SERIALIZABLE XACTION ISOLATION LEVEL scheme is heavier and thus maybe less efficient. See http://www.postgresql.org/idocs/index.php?mvcc.html =

Re: [SQL] Locking that will delayed a SELECT

On Fri, 18 Oct 2002, Achilleus Mantzios wrote: > Second small xaction T2's select statemenst will use values commited > before these select statements started. That is, these queries > will NOT see values updated by T1. > > The problem is solved > > a) Using SERIALIZAB

Re: [SQL] Sum of Every Column

resql 7.2.1), == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] #include #include

Re: [SQL] ORDER the result of a query by date

-(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mng

Re: [SQL] Upper / lower cases on table and column names

regards > Reiner Dassing > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece t

Re: [SQL] Returning a recordset and filling datatable in a .NET

Debug.WriteLine(ex.HelpLink) > Finally > CN.Close() > > It does not raise an exception so there are no real 'errors'; it just does > not give 'data' to the ADO.NET container. > > If I am asking this in the wrong mailinglist, then

Re: [SQL] How do you write this query?

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 to the mailing list cleanly >

[SQL] Problem: Referential Integrity Constraints lost

Thanx. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(e

Re: [SQL] Problem: Referential Integrity Constraints lost

ons" FROM "machclasses" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('', 'machclasses', 'vslsections', 'UNSPECIFIED', 'vslsecid', 'id'); The *LOST* triggers are 2 and 3. ===

Re: [SQL] Problem: Referential Integrity Constraints lost: Correction

I was wrong about parent side triggers only having disappeared. Triggers of both sides are missing. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax

Re: [SQL] Problem: Referential Integrity Constraints lost

On Wed, 6 Nov 2002, Stephan Szabo wrote: > On Wed, 6 Nov 2002, Achilleus Mantzios wrote: > > > > > Hi i think a hit a major problem on 7.2.1. > > I run 3 systems with postgresql 7.2.1. > > Its a redhat 7.1 for development, a redhat 7.3 for production > >

Re: [SQL] Problem: Referential Integrity Constraints lost

On Thu, 7 Nov 2002, Achilleus Mantzios wrote: > On Wed, 6 Nov 2002, Stephan Szabo wrote: > > > On Wed, 6 Nov 2002, Achilleus Mantzios wrote: > > > > > > > > Hi i think a hit a major problem on 7.2.1. > > > I run 3 systems with postgresql 7.2.1. > &g

Re: [SQL] primary keys

; TIP 4: Don't 'kill -9' the postmaster > ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of b

Re: [SQL] how to get the source table & field name of a view field

gt; > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4,

Re: [GENERAL] [SQL] Problem: Referential Integrity Constraints lost

On Thu, 7 Nov 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > After recreating the missing triggers should i upgrade > > to 7.2.3?? > > Make that "before". > > I frankly suspect pilot error here. Triggers do not simply

Re: [SQL] parse bug

(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 to the mailing list cleanly > =

Re: [SQL] SET DEFAULT

(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 to the mailing list cleanly > ===

Re: [SQL] importing a 7.2 db with contrib/tsearch to 7.3

indexes in intarray. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED

[SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars

uld be nice if someone knew something about it. == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EM

Re: [SQL] SQL -select count-

__ > Do you Yahoo!? > Yahoo! Web Hosting - Let the expert host your site > http://webhosting.yahoo.com > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister com

Re: [SQL] [GENERAL] FreeBSD, Linux: select, select count(*) performance

On Wed, 27 Nov 2002, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > Linux q1 > > > > dynacom=# EXPLAIN ANALYZE SELECT count(*) from noon; > > NOTICE: QUERY PLAN: > > > Aggregate (cost=20508.19..20508.19 rows=1 width=0)

Re: [SQL] master-detail relationship and count

es the link ID. For a 'R' it is the rtid of the route entry > -- > Gary Stainburn > > This email does not contain private or confidential material as it > may be snooped on by interested government parties for unknown > and undisclosed purposes - Regulation of Investig

Re: [SQL] master-detail relationship and count

group by r2.rtid) as subsel > where r.rtid = subsel.rid; > [gary@larry gary]$ psql -d nymr rtid | rtname | cnt > --++- > 1 | The Grange | 1 > (1 row) > [gary@larry gary]$ > > Gary > > On Friday 29 Nov 2002 10:36 am, Achilleus Mantzios w

[SQL] FreeBSD, Linux: select, select count(*) performance

nux vmstat gives no syscall info). The same results come out for every count(*) i try. Is it just the reporting from explain analyze?? Has any hacker some light to shed?? Thanx. ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tan

Re: [SQL] EXIST / NOT EXIST

(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 to the mailing list cleanly > =

Re: [SQL] SQL QUERY

en a column is of type 'SERIAL'). > > > > Pedro Igor > > > > == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] --

Re: [SQL] SQL QUERY

mply and nicely use sequences. > Pedro Igor > > - Original Message - > From: "Achilleus Mantzios" <[EMAIL PROTECTED]> > To: "Pedro Igor" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Tuesday, December 03, 2002 11:05

Re: [SQL] save data from views

s?? > > > > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4

[SQL] 7.3.1 index use / performance

NOTICE: QUERY PLAN: Index Scan using noonf_vcode on noon (cost=0.00..3046.38 rows=39 width=39) (actual time=0.09..8.55 rows=259 loops=1) Total runtime: 8.86 msec EXPLAIN Is something i am missing?? Is this reasonable behaviour?? P.S. Yes i have vaccumed analyzed both systems before the querie

Re: [SQL] 7.3.1 index use / performance

> index based on both fields. > What kind of queries do you have? How many records returns each "where" > condition? Use indexes on fields, on which condition result in smallest > amount of rows. > > Regards, > Tomasz Myrta > ===

Re: [SQL] A problem about alter table

ot null fields. > > I think you have to create trigger instead of altering table. > > > > Regards, > > Tomasz Myrta > > > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unreg

Re: [SQL] [PERFORM] 7.3.1 index use / performance

On Tue, 7 Jan 2003, Stephan Szabo wrote: > > On Tue, 7 Jan 2003, Achilleus Mantzios wrote: > > > i am just in the stage of having migrated my test system to 7.3.1 > > and i am experiencing some performance problems. > > > > i have a table "noon"

Re: [SQL] [PERFORM] 7.3.1 index use / performance

On Tue, 7 Jan 2003, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > About the stats on these 3 columns i get: > > Does 7.2 generate the same stats? (minus the schemaname of course) Not absolutely but close: (See attachment) > > Also, I would

[SQL] 7.3.1 function problem: ERROR: cache lookup failed for type 0

itoar" (integer) RETURNS integer[] AS '$libdir/itoar', 'itoar' LANGUAGE 'c' WITH ( iscachable,isstrict ); I also tried without the iscachable option with no luck (since it seems to complain about *type* 0) =====

Re: [SQL] [GENERAL] 7.3.1 function problem: ERROR: cache lookup failed

On Tue, 7 Jan 2003, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > Hi i had written a C function to easily convert an int4 to its > > equivalent 1x1 int4[] array. > > Does your function know about filling in the elemtype field that was > rece

Re: [SQL] [PERFORM] 7.3.1 index use / performance

=373 loops=1) Index Cond: (v_code = '4500'::character varying) Filter: ((report_date >= '2002-01-07'::date) AND (report_date <= '2003-01-07'::date)) Total runtime: 16.56 msec (4 rows) I thought PostgreSQL in some sense (hub.org) used FreeBSD, is there any 4.

Re: [SQL] [PERFORM] 7.3.1 index use / performance

On Tue, 7 Jan 2003, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > My case persists: > > After clean install of the database, and after vacuum analyze, > > i get > > Um ... is it persisting? That looks like it's correctly picked

Re: [SQL] SQL list table names

ierrez > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ====== Achilleus Mantzios S/W Engineer IT dept Dynacom

Re: [SQL] [PERFORM] 7.3.1 index use / performance

7.3.1, with a full clean installation also gives the same symptoms: Choosing the slow index, and after some (random) vacuums choosing the right index, and then after some vacuums chooses the bad index again. > > regards, tom lane > ===

[SQL] http://www.postgresql.org site problem

Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1: No pg_hba.conf entry for host 64.49.215.82, user portal, database 186_portal in /usr/local/www/www.postgresql.org/globals.php on line 130 == Achilleus Mantzios S

Re: [SQL] SQL function parse error ?

rsing process (imagine what it means for performance). ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of broadcast)-

Re: [SQL] Performance of request of type WHERE ... IN ( ... )

> TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > == Achilleus Mantzios

Re: [SQL] index on to_char(created, 'YYYY') doesn't work

t; > gpg public_key: http://dev.officenet.no/~andreak/public_key.asc > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.7 (GNU/Linux) > > iD8DBQE+JUtlUopImDh2gfQRAl1XAKCkEDKxRDys/Di1gLLRDx6h0TGiPwCeI4FN > DNdajyaQTd27f8MeaWZ+xUE= > =T3we > -END PGP SIGNATURE- > &g

Re: [SQL] index on to_char(created, 'YYYY') doesn't work

-usage etc? > > - -- > Andreas Joseph Krogh <[EMAIL PROTECTED]> > There will always be someone who agrees with you > but is, inexplicably, a moron. > > gpg public_key: http://dev.officenet.no/~andreak/public_key.asc > -BEGIN PGP SIGNATURE- > Version

Re: [SQL] index on to_char(created, 'YYYY') doesn't work

On Wed, 15 Jan 2003, Andreas Joseph Krogh wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Wednesday 15 January 2003 18:55, Achilleus Mantzios wrote: > > On Wed, 15 Jan 2003, Andreas Joseph Krogh wrote: > > > -BEGIN PGP SIGNED MESSAGE- >

Re: [SQL] optimal sql

chael Landin Hostbaek > FreeBSDCluster.org - an International Community > > */ PGP-key available upon request /* > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.pos

Re: [SQL] optimal sql

On Wed, 22 Jan 2003, Michael Paesold wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> wrote: > > > For a) do all the necessary tuning on PostgreSQL. > > With 1GB of Mem, you could set a value of shared_buffers to 10. > > Perhaps just a type, but that is way to mu

Re: [SQL] Scheduling Events?

rough to the mailing list cleanly > ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30-10-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---(end of broadcast)--

Re: [SQL] Scheduling Events?

FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-10-8981112 fax:+30

Re: [SQL] import error

ein, Hofkogelgasse 17 > Tel.: +43 2633 47530, Fax: DW 50 > http://members.aon.at/vecernik > > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ===

Re: [SQL] import error

On Tue, 28 Jan 2003, Achilleus Mantzios wrote: > On Tue, 28 Jan 2003, Oliver Vecernik wrote: > > > > > 1,1,"07.08.2001","11:35",1,1,2220,0,6.0,0.0,12,0,"",20,0,0,0,1,"Sarigerme","Asche > > Bucht","wolkenlos&quo

Re: CR/LF conversion (was: [SQL] import error)

> -- > VECERNIK Datenerfassungssysteme > A-2560 Hernstein, Hofkogelgasse 17 > Tel.: +43 2633 47530, Fax: DW 50 > http://members.aon.at/vecernik > > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe comm

Re: [SQL] CSV import

t; [(col_name,...)] > > Has anybody written such a function already? > > Regards, > Oliver > > -- > VECERNIK Datenerfassungssysteme > A-2560 Hernstein, Hofkogelgasse 17 > Tel.: +43 2633 47530, Fax: DW 50 > http://members.aon.at/vecernik > > > >

Re: [SQL] Delete 1 Record of 2 Duplicate Records

1 > > Thank you. > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > == Achilleus Man

Re: [SQL] automatic time/user stamp - rule or trigger?

e job as you wish. > > Thanks, > -Neal > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster > ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mn

Re: [SQL] PostgreSQL 7.3.1 multiple schema select query error:

Pipeline.java:472) > 15:43:40,128 ERROR [STDERR] at > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > 15:43:40,128 ERROR [STDERR] at > org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: > 1027) > 15:43:40,128 ERROR [STDER

Re: [SQL] Hex Integer Input

On Fri, 7 Mar 2003, Tom Lane wrote: > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > Hi, is there a way to enter integer data by their HEX > > representation?? > > I'm not sure that this is SQL-spec, but at least as of 7.3, you can > coerce a bitstring li

Re: [SQL] Hex Integer Input

On Fri, 7 Mar 2003, Joe Conway wrote: > Achilleus Mantzios wrote: > > Hi, is there a way to enter integer data by their HEX > > representation?? > > > > Is this what you want? > > regression=# select x''::int4; > int4 > -

Re: [SQL] cast of integer to bool doesn't work (anymore?)

On Fri, 21 Mar 2003, Eric Veldhuyzen wrote: > On Fri, Mar 21, 2003 at 04:46:17PM -0200, Achilleus Mantzios wrote: > > > > Currently (7.3) all input can be handled if fed as text. > > So what you can do is simply: > > > > my $sth = $dbh->prepare( &g

Re: [SQL] Listing Users

--(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:

Re: [SQL] How can I quit this: "Unique " to my table?

but not Null. > How can I do that? > SomeBody can help me please? > My table has information at the moment,what can I do for maintain > it? drop index b_prestamo_no_inventa_idx; > > > > -- =====

Re: [SQL] DELETE FROM A BLACK LIST

; TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-210-8981112 fax:+30-210-8981877 email: [EMAIL PROTECTED] [EMAIL PROTECTED] ---

[SQL] To ListAdms: Is pgsql-sql operating?

Is there any problem with [EMAIL PROTECTED] list? -- == Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+30-210-8981112 fax:+30-210-8981877 email: achill at matrix dot

Re: [SQL] how to determine array size

rforms this task, and do SELECT conname from pg_constraint where conrelid= and isinarr(blah,conkey); > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- ===

Re: [SQL] (no subject)

100 | f | f| f | bar| | (1 row) dynacom=# > > thanks > > -- ====== Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel:+

Re: [SQL] CREATE table1 FROM table2

On 17 Jun 2003, Rado Petrik wrote: > Hi, > > How I create table1 from other table2 . > > "cp table1 table2" create table table2 as select * from table1; > > Thanks. > > -- ====== Ac

Re: [SQL] create view error

lect * from lclass) lc on lc.lcid = l.lclass > left outer join > (select lnumber from lnumbers) ln on ln.lnid = l.lid and ln.lncurrent ^^^ select also lnid > = true > left outer join > (select * from compa

Re: [SQL] Logging select statements

> > Can you see a way to do this all in SQL that would be better/faster/more > efficient without using PHP/Perl ? > > Many thanks > Regards > Rudi. > > > > > > > > > > ---(end of broadcast)--

  1   2   3   >