[SQL] still sorting and casting problems

cast (log_date as date) desc select id, log_date from userlog order by date(log_date) desc Please help and thank's in advance ... jr __ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland

[SQL] how to cast this ?

(log_time as timestamp) is not working. Thank's in advance ... jr __ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland internet : www.pup.ch phone : +4141 790 404

[SQL] how to use nextval()

r any help ... jr __ 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: +417

[SQL] date_ge and time_ge

userlog : (See attached file: userlog.htm) __ 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

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

datum, '01.01.2004') Thanks in advance ... Juerg Rietmann __ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland internet : www.pup.ch phone : +4141 790 4040 fax : +4141

[SQL] function not running after upgrade from 7.03 to 7.2

COMMENT ON FUNCTION "buildUmfang"("bpchar") IS 'Diese Funktion generiert einen String mit allen Umfängen zum übergebenen Zylindertyp\n\n'; Query : SELECT *, (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang FROM zylinder; Thank'

[SQL] Function not running after upgrade 7.03 to 7.2

NT ON FUNCTION "buildUmfang"("bpchar") IS 'Diese Funktion generiert einen String mit allen Umfängen zum übergebenen Zylindertyp\n\n'; Query : SELECT *, (SELECT rtrim(buildUmfang(zylinder.z_typ), ','::text) AS rtrim) AS umfang FROM zylinder; Thank's in advan

[SQL] select only the first record

Hello there Is it possible to do a query and selecting only the first record in ad table ? e.g. select FIRST * from cars Tx in advance ... jr PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland

[SQL] how to add an new record from part of an old one

help ... jr insert into auftrag (a_nr, a_kurzbez) values (123456789, 'testtext') (select a_bez from auftrag where a_nr='200113672732') PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Swit

[SQL] calling a function within a view causes problems doing a pg_dumpall

r_z_typ)) AS r_z_alaenge_r, FROM rotation; Thanks for any help ... jr ==== PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 =

[SQL] how to do this join ?

orary store the kind of auftrag and then use it to get the definition (clear text) from another table. The query returns that typ is not known . How can I do it ? Thanks ... jr PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a

[SQL] Re: Still don't know how to build this string ?

NEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, plea

[SQL] Re: Still don't know how to build this string ? how to concat ??

NGUAGE 'plpgsql'; PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ---

[SQL] Still don't know how to build this string ?

011120 02760 02780 02800 02900 031200 031234 031352 select diam from zylinder where typ='01' should produce the string "800,840,870,1120" PFISTER + PARTNER, SYSTEM -

[SQL] how to build this string ?

031234 031352 select diam from zylinder where typ='01' should produce the string "800,840,870,1120" Thanks for any help ... jr PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreu

[SQL] postmaster not starting on my MS WIN NT

semaphore stuff. Thanks for any help ... jr (See attached file: cygwin.gif) PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315

[SQL] postgres DB temporary on NT

NT, all I need is the postgres DB or a 100% compatible on NT. Any ideas ?? Thanks in advance ... jr PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile

[SQL] copy a record from one table to another (archive)

Hello there Is it possible to move a record from one table to another to do a archive with a simple command like move ? Thanks jr PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone

[SQL] How to build this field

PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ---(end of broadcast

[SQL] no value for numeric filed in SQL statement causes an error

') The default for int/float fields is 0. Since I reuse the code of the referring page I don't like to have all fields assigned 0 at the beginning. Who can help ??? Thanks ... jr PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grund

[SQL] how to query this ??

ISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 queryDetails.doc

[SQL] monster query, how to make it smaller

(See attached file: monsterQuery.txt) PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315

[SQL] how to store this record ?? pg_atoi

=== PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315

[SQL] how to build this query ??? Please help !!!

3 120dm PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315

[SQL] SQL query not working when GROUP BY / HAVING is used

ylinder.Z_typ ANDZ_A_nr =NULL ANDZ_status = 'zcu' ORDER BY Zylinder_Typen.Z_durch_soll desc Whats wrong, according to the docs, the syntax is ok and it should be possible to use these keywords! PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315