Re: [GENERAL] Selecting a random row

m Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBiibF1Xdt0HKSwgYRAlJXAJ4nUpDfKBKCigPVMt8WpKG4gZmt4wCcD/ZC KHBlBl1+5FZ4pgqkZlyzWQA= =MrrE -END PGP SIGNATURE- ---(

Re: [GENERAL] Ping Mike Cox

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, is someone under way to tar-and-feather the originator of that nuisance? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux

[GENERAL] suggestion for "psql"

set the encoding? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBmGry1Xdt0HKSwgYRAgBYAJ4yxnCSDn3MgTvuLUs8t/bffC7HDwCeMDr2 j8np4ISSUI5AvjQE30AfvCM= =4f1P -END PGP SIGNATURE-

Re: [GENERAL] OID's

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 A little bit OT, but: is there a way of removing duplicate rows in a table without OIDs? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux

Re: [GENERAL] How many views...

then ;-) Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBqtqg1Xdt0HKSwgYRAmgJAJ9+PCiWIbnA2HR6QiGBlLXp9OQT6wCgg+gF rL3xzK6UP9AUFsnWxpk4zoE= =GQ0I -END PGP SIGNATURE-

Re: [GENERAL] Sorting in Unicode not working

locale dependant things? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFAd9fd1Xdt0HKSwgYRApjMAJ0aMilcPWmVSocljLD9PC2PpAXgvgCfRI+H I438s/mxrVmUHLwMOceMw6E= =yV1G -END PGP SIG

[GENERAL] verifying unicode locale support

, might help others) that my locale is working, but postgres (initdb and postmaster running with LANG=de_DE.utf8, -E UNICODE) still insists that upper('ä') equals 'ä'. What else can be wrong? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists kl

Re: [GENERAL] Filesystem vs. Postgres for images

2/3 perform extremely bad (as in the original post) So this guy will be better off with anything but ext2/3. That's why I switched from ext2 to reiser ~2 years ago (without any problems since). Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de --

Re: [GENERAL] Ordering YYYY MM DD in reverse chrono order

date_part( 'year', uu.add_date ) desc, date_part( 'month', uu.add_date ) desc, date_part( 'day', uu.add_date ) desc ; Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitt

Re: [GENERAL] Combining several rows

--- CREATE AGGREGATE join ( BASETYPE = text, SFUNC = join_text, STYPE = text ); Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFAsftE1Xdt0HKSw

Re: [GENERAL] How to tell when postmaster is ready

exit 1 fi sleep 1 done psql $MY_DATABASE Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFAyBlE1Xdt0HKSwgYRAtoKAJ9uWwaSQPyFae+q7bZFP6ovDRcTgwCcD2

Re: [GENERAL] making two tables with identical schemas appear as one

c way you want to bring the tables together. Without more specific information nobody will be able to help. Somehow I suspect you are looking for UNION: CREATE VIEW bothTables AS SELECT x, y, z FROM tableA UNION SELECT x, y, z FROM tableB ; Mit freundlichem Gruß / With kind regards

Re: [GENERAL] string is sometimes null ?

;) || coalesce(var2,'') || coalesce(var3,'') Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBW9CJ1Xdt0HKSwgYRAjg9AJoCA8rZYcDxsdey1neJNjysnPByagCfUIeL CJT69fhzoIY+RG

OT: spherical geometry (Re: [GENERAL] earthdistance is not giving ...)

? Mit freundlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBY5ZH1Xdt0HKSwgYRApMcAJ9en3fBq+OFiMReD1Bbm0/+0njkdACgmp4E yTuzi83I+8H3oRXKBPLjgH8= =t/Qo -END PGP SIG

Re: [GENERAL] lower/upper support and cyrillic

undlichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBY5Sf1Xdt0HKSwgYRAngzAJ9K862AAphOirF1+tyEKMO8HdaXsQCbByz8 zTF7OT800efKBWbLmhGZ1I8= =nTgO -END PGP SIGNATURE- -

Re: OT: spherical geometry (Re: [GENERAL] earthdistance is not giving ...)

lichem Gruß / With kind regards Holger Klawitter - -- lists klawitter de -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFBY+cQ1Xdt0HKSwgYRAr8oAJ9q+f02iMEPOdaSSc+oruLjVFYjygCfeO1a iSHsRLYwmmPPgsECGVGVq8w= =6T11 -END PGP SIGNATURE- ---

Re: [GENERAL] compiling ...

mike wrote: > > "cc -O -o pgsample pgsample.c -L/usr/local/pgsql/lib -lpq" went thru. You have to put the marked part into the rule for the linker. With kind regards / Mit freundlichem Gruß Holger Klawitter --

Re: [GENERAL] PgSQL behind a firewall

ow) or use a ssh tunnel. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] PgSQL behind a firewall

name. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send a

Re: [GENERAL] PGSQL on shared hosting

t fine (or at least it did with me). The only problem is that you cannot start postgres automatially that easily at boot time. Mit freundlichem Gruß / With kind regards Holger Klawitter - -- [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/vd2z1Xdt0H

Re: [GENERAL] bug in psql?

> When I start psql with the command -F $ (or any other saparator) the > output is still with the separator |. \f is only being honored when field alignment (\a) is turned off. Dunno, whether this is intended. Regards, Mit freundlichem Gruß, Holger Klawitter -- Holger Kla

Re: [GENERAL] importing tab delimited, text enclosed by "

t is probably easiest to remove the quote with a script (like the following perl program). while(<>){ chop; @a = split(/\t/,$_); @a = map { s/^"(.*)"$/$1/; $_; } @a; printf "%s\n", join("\t",@a); } Regards, Mit freund

Re: [GENERAL] latest version?

Pawel Wegrzyn wrote: > > Hi, > What is the latest version of PostgreSQL? > Is there something like 7.1? The most recent version 7.0.2. 7.1 is about to come - I am looking forward to it as well. Regards, Mit freundlichem Gruß, Holger Klawitter -- Holg

[GENERAL] Re: How to match percent sybmol in LIKE operator?

m with the backslash. In order to pass the backslash to the backend you have to escape the backslash as well: select * from xxx where yyy like '\\%'; It might be a good idea to point this out in the Postgresql book :-) With kind regards, Holger Klawitter -- Holger Klawitte

[GENERAL] is grouping over many columns avoidable?

gram 10 times slower...) With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de

[GENERAL] Re: Can you help a newbie?

t to make secret out of it :-) With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de

Re: [GENERAL] query varchar fields by length

ding on values of another another column can be done with "case": select case when length(col_var)<5 then col_a when length(col_var)>5 then col_b else col_5 end from tbl ; With kind regards / Mit freundli

Re: [GENERAL] Trying to get jdbc to work

self with the java option. OS is Linux, JDK1.3 /usr/lib/java/lib/classes.zip is not 1.3 (probably a leftover from an oder version). Remove it from your CLASSPATH (of your client) and you should be fine. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitte

Re: [GENERAL] Re: dumping strategy

relname NOT LIKE 'pg_%'; it should not be too hard to build something on top of that. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de ---(end of broadcast)

Re: [GENERAL] bug?: java won't read timestamps

Hi Dave, Thanks for your hint. It was indeed a problem with an older postgresql.jar sneaking into my classpath. With kind regards / Mit freundlichem Gruß Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://www.klawitter.de

[GENERAL] Subject: String Concatenation DOES work.

under 6.4.2 the following construct seems to work, however, all brackets are neccessary: SELECT * from x WHERE a ~~ (( '%' || b ) || '%' ); Thanks anyhow Holger Klawitter -- Holger Klawitter [EMAIL PROTECTED] http://wwwmath.uni-muenster.de/~holger

Indices (was Re: [GENERAL] query seems too slow)

Holger Klawitter -- Holger Klawitter +49 (0)251 484 0637 [EMAIL PROTECTED] http://www.klawitter.de/

[GENERAL] How to do this in Postgres

e) ---- I don't want to :-) Regards, Holger Klawitter -- Holger Klawitter +49 (0)251 484 0637 [EMAIL PROTECTED] http://www.klawitter.de/

[GENERAL] finding predecessor

Hi there, is there any convenient way to find the predecessor of a record given a particular order of the database? The following select seems a little bit too expensive. create table tuples ( i int, j int, m int, k int ); select * from tuples where ihttp://www.klawitt

Re: [GENERAL] stored procedure

Raigo Lukk wrote: > > Hi > > I can't find CREATE PROCEDURE in the guides. Try CREATE FUNCTION > What is the way of creating stored procedures in PostgreSQL? See above. You might also want to read Appendix II 42. dealing with additional languages. Reagrds, Holger

[Fwd: [GENERAL] Re: alter table]

Holger Klawitter wrote: > > Raigo Lukk wrote: > > > > Hi > > > > > > > alter table tmp add column last text; > > > > I had this same problem, turned out that PostgreSQL don't have > > this feature :-( > > > > So only way i