Re: [SQL] plpgsql notify trigger

2001-02-28 Thread Yury Don
Hello George, Once, Thursday, March 01, 2001, 12:30:07 AM, you wrote: GY> [postgres 7.0.2, x86 linux] GY> I am trying to use a trigger to perform an sql 'notify' command. GY> I do something like: GY> CREATE FUNCTION run_changed() RETURNS opaque AS ' GY>declare GY> nm text; GY>beg

Re: [SQL] Trouble with subqueries

2001-01-19 Thread Yury Don
Hello Jussi, Once, Friday, January 19, 2001, 12:34:50 PM, you wrote: JV> I have the following two tables: JV> create table movies ( JV> name varchar(80), JV> info varchar(80), JV> length int, JV> primary key (name) JV> ); JV> create table ratings ( JV> name varchar(80), JV> userid

Re: [SQL] python+postgresql

2001-01-18 Thread Yury Don
Hello Sharmad, Once, Wednesday, January 17, 2001, 12:24:11 AM, you wrote: SN> I wanted to compile python will an installed postgres package ...can i do it .How? SN> TIA SN> Sharmad There are 2 known python postgresql modules - PyGreSQL and PoPy. PyGreSQL is in Postgresql distribution, PoPy you

Re: [SQL] Query Help

2000-12-27 Thread Yury Don
Hello Brian, Wednesday, December 27, 2000, 9:20:53 PM, you wrote: BCD> What do I have to do a query where information in table1 is not in table2 BCD> I am looking for something like BCD> Select table1.firstname where table1.firstname is not in table2.firstname BCD> and table2.date='yesterday'

Re: [SQL]

2000-10-30 Thread Yury Don
Hello Lengyel, Once, Monday, October 30, 2000, 5:36:23 PM, you wrote: LF> Hello everybody! LF> I need some help with a simple query. LF> I've got a problem with getting a maximum value from a very large table LF> (1000+ rows): LF> I have table: LF> CREATE TABLE TABLE_A LF> ( LF> COL1 INT, LF

Re: [SQL] Argument variables for select

2000-08-28 Thread Yury Don
Andreas Tille wrote: > > Hello, > > I want to use the following construct in a stored function: > > Create Function VarSelect ( varchar, varchar ) >returns int >As ' > Declare num int ; > > Begin >Select Into num Count(*) From $1 Where $2 ; >return num; >

Re: [SQL] weird structure

2000-08-27 Thread Yury Don
Renato De Giovanni wrote: > > > > Consider the following tables/fields: > > > table "person": fields "p_id", "p_name". > > > table "person_attribute": fields "a_id", "a_name". > > > table "person_data": fields "d_person_id", "d_attribute_id", > > > "d_value". > > > > > > Also consider that a pers

[SQL] Re: [GENERAL] Getting the result of a query using COUNT(*)

2000-08-24 Thread Yury Don
Jackson Ching wrote: > > Hi, > > I'm using JSDK 2.0 and IBM JDK 1.3 on RedHat Linux 6.2 > > As i test my servlet, I got errors saying count(*) column not found in a >query like this > > SELECT COUNT(*) FROM MyTable > > in my rs.getint("COUNT(*)"); in oracle

Re: [SQL] weird structure

2000-08-24 Thread Yury Don
[EMAIL PROTECTED] wrote: > > Hi, > > Consider the following tables/fields: > table "person": fields "p_id", "p_name". > table "person_attribute": fields "a_id", "a_name". > table "person_data": fields "d_person_id", "d_attribute_id", > "d_value". > > Also consider that a person may not have dat

Re: [SQL] sequences in functions

2000-08-18 Thread Yury Don
Hello Graham, Friday, August 18, 2000, 6:24:15 PM, you wrote: GV> I am having problems referencing sequeces in a function, I think because of GV> the '' characters. The function I am creating is a follows: - GV> CREATE FUNCTION InsertClient ( varchar, varchar, varchar, varchar, varchar, GV> var

Re: [SQL] Q:Postgres 7.0 & Access'97?

2000-06-14 Thread Yury Don
Hello Emils, Once, Tuesday, June 13, 2000, 8:42:05 PM, you wrote: EK> I am using Postgres 7.0 on SuSE Linux 6.2 and Postdrv.exe EK> 6.50. (as downloaded from /latest/ dir of PG FTP site EK> yesterday). EK> Now, I have experienced 4 issues immediately with Postgres via EK> ODBC from Access

Fwd: RE: [SQL] dump from access to pg on linux

2000-06-13 Thread Yury Don
This is a forwarded message From: Fred Lecul <[EMAIL PROTECTED]> To: Yury Don <[EMAIL PROTECTED]> Date: Wednesday, June 14, 2000, 10:45:55 AM Subject: [SQL] dump from access to pg on linux ===8<==Original message text=== I did this by using the postgres

Re: [SQL] dump from access to pg on linux

2000-06-13 Thread Yury Don
Hello rocael, Once, Wednesday, June 14, 2000, 12:11:40 AM, you wrote: run> I have a DB in access, and I wanna pass it to pg7 on my linux box, do somebody run> know which is the best (and easy) way to do that?? like a dump?? We used Pgupt for this: http://dspace.dial.pipex.com/boylesa/pgupt/pgup