[GENERAL] Indexing arrays

I'd like to index an array. This is my table: template1=> \d test_array Table= test_array +--+--+---+ | Field | Type| Length| +--+

RE: [GENERAL] Clarification

You could of course try Java and JDBC as Java runs everywhere. Then you could run your application on Mac, Windows and Linux as you see fit. /Roger -Original Message- From: Alain Toussaint [mailto:[EMAIL PROTECTED]] Sent: den 6 december 2000 08:10 To: KuroiNeko Cc: [EMAIL PROTECTED] Subj

Re: [GENERAL] Overhead of tables.

On Tue, Dec 05, 2000 at 09:34:19PM -0800, some SMTP stream spewed forth: > At 11:48 PM 12/5/2000 -0500, you wrote: > >Soma Interesting <[EMAIL PROTECTED]> writes: > > > I'd like to get an idea of the overhead introduced by large quantity of > > > tables being hosted off a single PostgreSQL server

Re: [GENERAL] MacIntosh

I have a friend that networked his iMac and MacTV to his Linux file server. There is a program out there called Netatalk (?). Basically it is the equivalent of Samba for Appletalk. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com - Original Messag

[GENERAL] syntax of outer join in 7.1devel

Hi I just grabbed the latest development version from the CVS, because i need the outer join functionality. But how do I make an outer join? What's the syntax? I will RTFM if someone points me to the docs :-) Poul L. Christiansen

Re: [GENERAL] syntax of outer join in 7.1devel

"Poul L. Christiansen" <[EMAIL PROTECTED]> writes: > But how do I make an outer join? > What's the syntax? > I will RTFM if someone points me to the docs :-) I'm afraid I haven't updated the FM yet :-( ... but you could look at the examples in the JOIN regress test, src/test/regress/sql/join.sql

Re: [GENERAL] Clarification

ashley <[EMAIL PROTECTED]> writes: > I wish to run postgresql on a Linux (Slackware) server over a LAN. > The client must reside on Apple MacIntosh (12 of them) What are you planning to write the client in? If you haven't decided yet, one possibility is Tcl. It runs fine on Macs. I'm not sure

[GENERAL] Design and development info

Hi, I have been looking for some resources for database design and development. Not specifcally for Postgres ,but more generalized information about the best way to design DBs and the pitfalls that are easy to fall into. I am a competent programmer, and I have worked with database

[GENERAL] MySQL-esque sec_to_time() function

Hello,   I'm converting from MySQL to PostgreSQL (actually flipping/flopping back) and have a question:     MySQL has a cool function sec_to_time() which converts your number of seconds to hh:mm:ss   I've read thru the mailing lists and am basically trying to implement the following:     MySQ

Re: [GENERAL] Many postmasters...

Jean-Christophe Boggio wrote: > Using Linux RH7.0 with correct gcc and glibc, PG7.03, Apache 1.3.14 > and PHP4. We have several unresolved questions : > * Is it normal that > ps aux |grep postgres > shows (what we want : processes own by postgres) multiple postgres > backends (which seems

[GENERAL] How To Log User Name + Database?

Can anyone tell me how to log the db user name and db name to the server log? Is this possible at present? Couldn't find anything about it in the docs or deja... Regards, Ed Loehr

Re: [GENERAL] How To Log User Name + Database?

Ed Loehr <[EMAIL PROTECTED]> writes: > Can anyone tell me how to log the db user name and db name to the server > log? Is this possible at present? Offhand I don't think that happens at the moment, but it does seem like it'd be a good idea to have a backend do an elog(DEBUG) at startup that ment

Re: [GENERAL] How To Log User Name + Database?

* Tom Lane <[EMAIL PROTECTED]> [001206 11:25]: > Ed Loehr <[EMAIL PROTECTED]> writes: > > Can anyone tell me how to log the db user name and db name to the server > > log? Is this possible at present? > > Offhand I don't think that happens at the moment, but it does seem like > it'd be a good id

[GENERAL] localization design for DB structures?

Hello, I asked this a while back but didn't get a reply, so I'm trying again (hopefully explaining my question better, too). I'm setting up a basic "document manager" system that stores various short text documents which are flagged for display on certain sections of our website. That's the easy

RE: [GENERAL] MySQL-esque sec_to_time() function

Hi George, Difference of two timestamps directly : dbtest=# select 'now'::timestamp - '2000-12-06 13:47:57+00'::timestamp as "Time Interval"; Time Interval --- 02:49:34 (1 row) Number of seconds converted to hh:mm:ss : dbtest=# select '12345 seconds'::interval as "Time Interval";

[GENERAL] apache .htaccess / postgresql module

Hello,   I had a question regarding using PostgreSQL as the authorization database for Apache.  Previously I was using Apache authentication module for MySQL v2.20 (mod_auth_mysql) and was wondering if there was an equivalent module for use with PostgreSQL?   I must add I'm really impressed w