[SQL] How NULL is interpreted in Pgsql

Dear Friends, I created a table with no 'unique constraints' which is depicted as follows. create table junk (id int, name varchar); Then, i inserted some records into the table. My table contents is listed below. id | name -+-- 1001.00 | bolt 1002.00 | nut

Re: [SQL] error message...

Hi Sven, There is a startup option, "-N" of how many clients are allowed to be connected simultaneously. The default is 32 in the source code, not sure if SuSE has it changed. You can also alter the default maximum before compiling it, but I get the feeling you've installed pre-built packages.

Re: [SQL] execute client application from PL/pgSql

Hi, It's exact URL is : http://www.greatbridge.org/project/phppgadmin/projdisplay.php For PostgreSQL related stuff like this, you can look them up at : http://techdocs.postgresql.org/oresources.html I still have to add a lot of the GreatBridge.org projects to it, as they're expanding quite ni

[SQL] system time

is there any function from which i can get system time? Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie ---(end of broadcast)--

Re: [SQL] system time

select now(); ??? + Justin Seema Noor wrote: > > is there any function from which i can get system time? > > > Do You Yahoo!? > Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk > or your free @yahoo.ie address at http:/

[SQL] Case insensitive string comparison?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there an operator for case insensitive string comparison, or should I use regular expression matching with ~* '^string$'? Bye Borek - -- = BOREK LUPOMESKY

Re: [SQL] working with stored procedures (fwd)

> regy1'> output_rec := user_rec; Here you can't assign the entire record (user_rec) into a variable. You can assign either one of the following. 1. output_rec := user_rec.fname; 2. output_rec := user_rec.lname; 3. output_rec := user_rec.fname || user_rec.lname (This will concantenate the two f

Re: [SQL] How NULL is interpreted in Pgsql

Guru Prasad <[EMAIL PROTECTED]> writes: > 'select * from junk where id != 11'; > To my surprise, it displayed all the records except those which had > 'NULL' in the 'id' field. This is correct per spec: NULL is not a value and it doesn't act like one. See any discussion of SQL NULLs --- Bruce's b

[SQL] varbit question

Hi, I thought I posted this but I don't see it on the server so let's try again: I have an Oracle script that I want to convert to pgsql. I've got a sed script that does most of the mappings but it doesn't look like raw is supported. In the docs, there is mention of varbit(n) but if I use the (n

Re: [SQL] system time

Try using: SELECT now() It should do what you want. If not there are a whole pile of date functions. Look them up in the Users Guide. Hope this is helpful. Jason --- Seema Noor <[EMAIL PROTECTED]> wrote: > is there any function from which i can get system > time? > > ___

[SQL] Select between two connections

Hello everyone, I would like to perform a Select statement that accesses tables and finds matching fields in two separate databases. For example, I have two connections to two separate database objects on the same Postgres server. I would like to retrieve information from a table in one databa

[SQL] Please dont flame

Sorry to bother, Just making sure my newsfeed works -- Olivier PRENANT Tel:+33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] --

Re: [SQL] Case insensitive string comparison?

On Tue, May 15, 2001 at 02:48:24PM +0200, Borek Lupoměský wrote: >Is there an operator for case insensitive string comparison, or > should I use regular expression matching with ~* '^string$'? possibility: - use upper() / lower() inside query - regex operators: ~* or !~*

[SQL] Re: how to remove ?

Hi Perhaps you have sent you commands in the subject-line. All commands should be sent by putting them in the body of the message. Best regards Per-Olof Pettersson >> Original Message << On 2001-05-14, 06:56:48, [EMAIL PROTECTED] ("Subhramanya Shiva") wrote reg

[SQL] Re: Select between two connections

Hi I think one way of accomplishing this is to use ODBC and thus an ODBC-client for the selects. There does not seem to be any support for it in Postgresql. (If not in later versions). Though I am not very experienced with it so someone more experienced should perhaps answer the question. Ho

[SQL] Re: How NULL is interpreted in Pgsql

Hi In the condition "where id != 11" you state that the value should differ from null. For a value to be different than 11 it has to be a value in the first place. So in reality you state two things: 1. id must be a value 2. id must differ from 11 It is nothing specific with Postgresql but co

Re: [SQL] Auto incrementing an integer

Sylte wrote: >How do I construct a datatype that autoincrement in postgreSQL? > Use the SERIAL data type instead of an INT4.Serial is an integer (INT4) that's default value is base on a sequence. for example... create table foo ( my_id serial not null, my_data text ); ---