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;
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
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
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
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
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
[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
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
>
> 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
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
"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
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
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
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
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
"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
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-
17 matches
Mail list logo
