[GENERAL] FW: URGENT: pgsql on the web server - memory problems....

2000-10-05 Thread Nikolay Mijaylov
-- The reboots are for hardware upgrades! "http://www.nmmm.nu"; < [EMAIL PROTECTED] > -Original Message----- From: Nikolay Mijaylov [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 1:28 PM To:

[GENERAL] Re: [SQL] SubSelect as a column

2000-02-07 Thread Nikolay Mijaylov
Define this as function: SELECT COUNT(t.techid) FROM ticket t WHERE t.techid = $1 Then use this SELECT u.idnum, u.username, func(u.idnum) FROM users u; -- The reboots are for hardware upgrades! "http://www.nmmm.nu; <[EMAIL PROTE

[GENERAL] Re: [SQL] Bug in CEIL?

2000-01-19 Thread Nikolay Mijaylov
PostgreSQL 6.4.2 : - Welcome to the POSTGRESQL interactive sql monitor:  Please read the file COPYRIGHT for copyright terms of POSTGRESQL      type \? for help on slash commands   type \q to quit   type \g or terminate with semicolon to execute query You are currently conn

Fw: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Nikolay Mijaylov
  --The reboots are for hardware upgrades!"www.nmmm.nu"; <[EMAIL PROTECTED]> - Original Message - From: Nikolay Mijaylov To: pgsql-general Sent: ÐÏÎÅÄÅÌÎÉË, äÅËÅÍ×ÒÉ 27, 1999 03:27 Subject: Re: [GE

Re: [GENERAL] get the previous assigned sequence value

1999-12-09 Thread Nikolay Mijaylov
Why you discuss it The problem is quite clean and it was solvev many years ago. 1. Get the *next* sequence value: select nextval("gogo_seq"); 2. Store it into a variable (for example $X) 3. Insert proper data (and and sequence value) insert into gogo values( $X, 'NMMM', 'mailto:[EMAIL PR

Re: [GENERAL] insert BLOB

1999-10-14 Thread Nikolay Mijaylov
BLOb is OID CREATE TABLE images (imagefield oid); - Original Message - From: David Lanier <[EMAIL PROTECTED]> To: PGSQL-General <[EMAIL PROTECTED]> Sent: 14 Îêòîìâðè 1999 ã. 18:15 Subject: [GENERAL] insert BLOB > I'm relatively new to Postgres. > > I'd like some help setting up a BLOB

Re: [GENERAL] Set operator.

1999-07-13 Thread Nikolay Mijaylov
I know it is not the same but try this: select table1.value1 from table1 where table1.value1 not in (select table2.value2 from table2) well im never try this to this moment. :) but u can nmmm.hypermart.net w3.nsi.bg/linux www.nsi.bg/nmmm - Original Message - From: Stuart Rison

Re: [GENERAL] powered by postgresql

1999-06-02 Thread Nikolay Mijaylov
http://sims.skillbrokers.bg - very complex & large database for recruiting ppl (job search) linux/postgres/cgi_core (this last can be seen at: http://nmmm.hypermart.net/ ) greetings niki - Original Message - From: Tim Joyce <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Rachel Greenham