[GENERAL] php - pgsql connection

Hi, I know it's not a PHP3 mailinglist but the question is somewhat related to pgsql. I would like to know what's the problem with following line: $dbConn = pg_Connect( " host=$host user=$user password=$password port=$port dbname=$dbname"); The php variables are filled with the appropria

[GENERAL] C function returning multiple values (or tuples)

Hello PostgreSQL friends! I've read Yin-So Chen's interesting thread regarding the STORED PROCEDURE issue, and I learned that C functions can only return one value. BUT I also read at the TODO list that "Functions returning sets don't really work right" (look it up). Okay, even if it doesn't "w

Re: [GENERAL] Convert MS access database into PostgreSQL

How do you import text data into Postgres? You should be able to export Access data into text format and then - if it is possible to import that text - import that text into Postgres. This would be generally interesting to someone working in, for example, computer assisted reporting (CAR), where

Re: [GENERAL] Convert MS access database into PostgreSQL

On Fri, 15 Oct 1999, Duncan Kinder wrote: > How do you import text data into Postgres? > > You should be able to export Access data into text format and then - if it > is possible to import that text - import that text into Postgres. > > This would be generally interesting to someone working in

Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL

Mike (and Doran) - Ah, that's the keyword I needed: grepping for 'upsiz' in my personal postgresql archives finds s tool called 'pgupt' at: http://dspace.dial.pipex.com/boylesa/pgupt/pgupt.shtml I haven't used it, but it seems to be targeted at exactly this task. Ross On Fri, Oct 01, 1999 at

Re: [GENERAL] BIG Data and Perl

On Fri, 15 Oct 1999, Andy Lewis wrote: > -- cut -- > $result = $conn->exec("$query"); > > $ntuples = $result->ntuples; > print STDOUT "Total: $ntuples \n\n"; > > while ( @row = $result->fetchrow ) { > do some stuff here...ie, open file and read >

Re: [GENERAL] How to import data from MDB or pipe delimited file into PostgreSQL

--- "Ross J. Reedstrom" <[EMAIL PROTECTED]> wrote: > Mike (and Doran) - > Ah, that's the keyword I needed: grepping for > 'upsiz' in my personal > postgresql archives finds s tool called 'pgupt' at: > > http://dspace.dial.pipex.com/boylesa/pgupt/pgupt.shtml > > I haven't used it, but it seems

[GENERAL] how to insert a date

hi, Can anyone help me -- how to insert a date value into a postgresql db Thanks in advance. __ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com

Re: [GENERAL] how to insert a date

Thanks. 1. But, How to get use the general functions like char_length( ); Like in Oracle, we've select (5*6) from dual; What is the substitute for the dual in pg DB. 2. Is it true that 6.5.2 doesn't support foreign keys. This is what my qn. really was. Sorry, had I written the last qn

Re: [GENERAL] User defined function

hi... > > > CREATE FUNCTION startofregyear(date) RETURNS date AS ' > > SELECT text_datetime(''01/12/'' > float8_text(datepart(''year'',$1)-1)) > > AS answer; > > ' LANGUAGE 'SQL'; > > absolutely not, I tried that already. > I get "attribute not found" error wherever the opening double-quot

Re: [GENERAL] php - pgsql connection

hi... > I would like to know what's the problem with following line: > $dbConn = pg_Connect( " host=$host user=$user password=$password port=$port >dbname=$dbname"); > > The php variables are filled with the appropriate values. are you sure? > Warning: Unable to connect to PostgresSQL

[GENERAL] jdbc problem

Hi, I am using postgresql under linux. Now that I need to build up the jdbc driver for postgresql, when I make under the directory /src/interfaces/jdbc.. I get an error stating '(u' unexpected syntax... The version returned by the make is 1.0b4. The makeVersion.java file returns jdbc0 as the

[GENERAL] Problem with Pg.pm

[My apologies if this is the wrong list for this question] Hi, I'm having trouble getting Pg.pm (the perl<->postgres module) working. I have installed the following rpm's from the postgresql ftp site: postgresql-6.5.1-2.i386.rpm postgresql-devel-6.5.1-2.i386.rpm postgresql-perl-6.5.1-2.i

Re: [GENERAL] User defined function

Hi Moray, Try the following: create function test(date) returns date as ' select (text_datetime(\'01/12/\' || float8_text(date_part(\'year\', $1) - 1)))::date as answer; ' language'sql'; Test: (my DATESTYLE is set to European) sele

[GENERAL] Functions documentations

Hi !! I am looking for a complete list of functions we have under PostgreSQL. Where can I found this documentation ? If there is no documentation, I would be please to write one with samples. In this case, send me your experience with source for each functions you have try at my direct e-mail.