Re: [SQL] int2+float8 problems

"guard" wrote: >select trn_qty,amount2,trn_qty*amount2 from invo > >trn_qty INT2 >amount2 FLOAT8 > >+-+-+--+ >| trn_qty | amount2 | ?column? | >+-+-+--+ >| -1 |7678 | 7678 | > >what to get -7678 This works in 7.1be

Re: [SQL] int2+float8 problems

compile ./configure --prefix=/home/pgsql --enable-multibyte run Redhat 6.1 & 6.2 postgresql7.0.3 not run regression tests "Tom Lane" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "guard" <[EMAIL PROTECTED]> writes: > > select trn_qty,amount2,trn_qty*amount2

[SQL] Re: [PHP] novice question

Andy, I'm forwarding your e-mail to the PGSQL-SQL list, where I think you'll find more help on CONSTRAINTS. As I don't use them a lot, myself, I don't have a good answer for you. > i'm running postgresql on apache with php4. i am working with a > postgresql > table which was set up by a

[SQL] Re: Help needed -> ERROR: record arow has no field description

Hi all, Solved my own problem. I was just misreading the error message. It was actually TELLING me the problem (I was referencing a table with no field called "description" in the select, but trying to use it in the loop. Sorry for disturbing people. As an aside, this has motivated me to add

Re: [SQL] plpgsql notify trigger

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] int2+float8 problems

"guard" <[EMAIL PROTECTED]> writes: > select trn_qty,amount2,trn_qty*amount2 from invo > trn_qty INT2 > amount2 FLOAT8 > +-+-+--+ > | trn_qty | amount2 | ?column? | > +-+-+--+ > | -1 |7678 | 7678 | What platform are you on, and how did

[SQL] int2+float8 problems

select trn_qty,amount2,trn_qty*amount2 from invo trn_qty INT2 amount2 FLOAT8 +-+-+--+ | trn_qty | amount2 | ?column? | +-+-+--+ | -1 |7678 | 7678 | what to get -7678 thanks

[SQL] Re: Daily Digest V1 #282

> > create trigger run_changed_tr after update on runs for each row >execute procedure run_changed(); > > BUT, when I update the table, I get: >ERROR: parser: parse error at or near "$1" > > It looks like the *name* (or it's alias here: $1.run_name), not the *value* of the >variable

Re: [SQL] mysql's "replace into..."

Jeff, > Thanx for your help. I found replace into to be a nice convience since my > primary keys are often expressions build from several fields which I want to > keep unique. Replace into enforces this uniqueness. I was learning SQL > when I started this project so I didn't know this was non-

[SQL] plpgsql notify trigger

[postgres 7.0.2, x86 linux] I am trying to use a trigger to perform an sql 'notify' command. I do something like: CREATE FUNCTION run_changed() RETURNS opaque AS ' declare nm text; begin nm := NEW.run_name; notify nm return null; end; ' LANGUAGE 'plpgs

Re: [SQL] mysql's "replace into..."

Jeff, > I'm in the process of migrating a production database and related > applicatoins from mysql to postgresql. I've just not been very impressed > with mysql's stability, that is I'm trying to make my phone stop ringing. Surprising. I have a number of gripes with MySQL (of which REPLACE IN

[SQL] Updatable Views

Tom, A while back you posted a rather intimidating e-mail regarding updatable views. Thanks to some reading (Fabian Pascal) I understand what you were talking about. My question is, are updatable views implemented in 7.1, or is this still vaporware? And, for that matter, when i

[SQL] Re: [GENERAL] Debug messages in beta5

I am adding the DEBUG messages to the open items list. > Maybe this will help in evaluating beta5. Here is some debug output > from serverlog while the system was doing a restore to 7.1b5 from a > pg_dump file created on a 7.0.3 box: > > DEBUG: MoveOfflineLogs: remove 003D > DEBUG

Re: [SQL] SELECT DISTINCT problems

From: "SCAHILL KEVIN" <[EMAIL PROTECTED]> > I would like to pull each distinct value of LecturerName with any one > corresponding ProjectCode value, it does not matter what the ProjectCode > value is, but all attemps at this have failed so far. > > I have tried this but it does not work: > > Set

Re: [SQL] SELECT DISTINCT problems

SCAHILL KEVIN <[EMAIL PROTECTED]> writes: > I have tried this but it does not work: > Set rsLecturers = Server.CreateObject("ADODB.Recordset") > sqlLect = "Select LecturerName, MIN(ProjectCode) from tblSuggestions WHERE > LecturerName IN ( SELECT DISTINCT LecturerName FROM tblSuggestions)" > rsL

[SQL] SELECT DISTINCT problems

Hi there, I'm having a lot of trouble with one sql statement and I wonder can you help. I My problem is the following...there are two field name in the the table named LecturerName and Projectcode. Each ProjectCode vulue is unique within the table but there can be many entries in the table with t

Re: [SQL] Need your help

Jie Liang wrote: > e.g. > Try: > > CREATE TABLE emp ( > id int4 primary key, > empname text, > salary int4, > last_date datetime, > last_user name); > > CREATE FUNCTION emp_stamp () RETURNS OPAQUE AS > BEGIN >update emp set last_date=''now''::timestamp where id=NEW.id;