splay a value of type record
I think/hope I'm missing something pretty stupid, but I can't figure
out what it might be. Any help would be appreciated. There might even
be a quite better way.
Eric.
Here's a script to reproduce the problem:
CREATE TABLE mytable (id int, obj text);
Thanks to both of you gentlemen. I actually had to restart Postgres
after installing ActiveState Perl before I could successfully run
createlang and add the language. Seems to be working now, though.
Cheers,
Eric
Magnus Hagander wrote:
Hi all,
I am throughly enjoying using Postgres 8.0 on
Can I still build pl/perl against it? Better
yet, is there a pl/perl binary for Windows?
Many thanks,
Eric
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
e would be much
appreciated.
Many thanks,
Eric
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Eric D Nielsen wrote:
> > I recently tried to upgrade from the 7.2.1 PostGreSQL package on
> > Debian Stable to the 7.4.6 PostGreSQL package on Debian Testing. The
> > automatic update failed, message included below.
postgres/dumpall/7.2/ directoty.
Can anyone advise me of how to proceed? I would prefer to stick with the
Debian
packages, but if I must can deal with compiling from source for intermediate
versions, etc.
Thank you.
Eric Nielsen
- Begin script output
The postmaster did not start after
I need help to connect DBDesigner4 linux in ODBC to postgres.
I'm having a problem connecting to a remote Postgres db using ODBC from
my Debian Linux laptop. I've got ODBC set up (UnixODBC). In DBDesigner
I'm simply trying to set up the connection using the ODBC datasource,
but I keep getting the
age will be more accurate then the one before :)
Thanks every body for your advices.
Eric.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Sun, 2004-11-07 at 14:54, Martijn van Oosterhout wrote:
> There is an ODBC driver for windows that will then talk native to the
> PostgreSQL database, why not use that?
Because I'm on linux :p
---(end of broadcast)---
TIP 1: subscribe and un
to make it work with postgres, I don't know
if I will have a non-optimized database at the end... because
DBDesigner4 won't take profit of postgres features?
On Sun, 2004-11-07 at 00:29, Alvaro Herrera Munoz wrote:
> On Sat, Nov 06, 2004 at 10:32:30PM -0500, Eric wrote:
> > Is t
Hi Sim,
Got it! Set the Row Versioning Box in Page 2 of the DSN to checked and
the problem no longer occurs. Many thanks for helping me along.
Cheers,
Eric
Sim Zacks wrote:
Maybe you need some ODBC settings reconfigured:
Here's what I have, I read a couple of these settings on various
ODBC. Any other suggestions?
Thanks,
Eric
Sim Zacks wrote:
After the stored procedure is run, call requery on the form that was
updated.
We are in the middle of moving Access implementations to PostGreSQL.
I'd be happy to trade war stories, if you'd like.
Thank You
Sim Zacks
IT Manager
o.
Many thanks,
Eric
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
k up individual rows over and over.
Any ideas would be much appreciated.
Many thanks,
Eric
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Is there something to interface postgreSQL with QMail to store mails in
pgsql instead of using mbox or maildir?
Or maybe it's not a good idea to do that?
I think there is some adavantages...
---(end of broadcast)---
TIP 3: if posting/reading thro
Hi Steve and Tom,
Thanks for the tip, I was clearly not reading the error message closely
enough.
I copied libperl.so into /lib, and now everything works.
Many thanks,
Eric
Steve Atkins wrote:
On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote:
Hi,
I have an installation of Postgres 7.4.2
solve this? (yes not wanting
to compile plperl is plain old laziness, but I do have reservations
about recompiling the perl interpreter)
Any ideas would be helpful.
Thanks,
Eric
---(end of broadcast)---
TIP 5: Have you checked our ext
Hmm that's a really intesting idea, Tino. Since we're probably
talking about 100 numbers max, a query on this table would work
fairly fast, and operationally simple. I'll think about that.
Thanks,
Eric
Tino Wildenhain wrote:
Hi,
Am Mi, den 20.10.2004 schrieb Eric E
ns't involve a complicated mapping to boxes.
Thanks,
Eric
Andrew Sullivan wrote:
On Tue, Oct 19, 2004 at 11:19:05AM -0400, Eric E wrote:
My users will draw a number or numbers from the sequence and write to
the field. Sometimes, however, these sequence numbers will be discarded
(after a tran
again for any ideas.
Cheers,
Eric
Tino Wildenhain wrote:
Hi,
On Tue, 2004-10-19 at 01:16, Eric E wrote:
Hi,
I have a question about sequences. I need a field to have values with
no holes in the sequence. However, the values do not need to be in order.
My users will draw a number or number
f the holes, step through those holes, and then start
generating new numbers. Unfortunately, this involves doing a table scan
each time - before I generate the number, and does not produce the
transaction-safety I want.
Does anyone have any better ideas? Places I should look?
Thanks,
holes, step through those holes, and then start
generating new numbers. Unfortunately, this involves doing a table scan
each time - before I generate the number, and does not produce the
transaction-safety I want.
Does anyone have any better ideas? Places I should look?
Thanks,
It is possible to mainteners of this list to keep this list from
"/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Now, we are invade with users that aren't used to read the manua
ments:
int4, _varchar (array of varchars)
Any help would be appreciated, I'm not incredibly experienced in these
matters.
Thanks,
Eric
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
however it looks very useful for mapping their concepts to SQL.
Eric
On Friday, Oct 15, 2004, at 20:25 US/Eastern, George Essig wrote:
Eric D. Nielsen wrote:
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the conce
types/functions/etc. I was wondering if anyone else has tried to use
their approach as a base for their historical databases in PostGreSQL
and has any "lessons learned" to share.
Thank you.
Eric Nielsen
---(end of broadcast)---
TIP 9: the
> From: Greg Stark <[EMAIL PROTECTED]>
> Subject: Re: Need some advice on appropriate PL strategy...
> Message-ID: <[EMAIL PROTECTED]>
>
> "Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
> > I guess I could alternatively just code up a simple mai
r" in another PL method?
Thank you,
Eric Nielsen
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi,
I have a running PHPBB mySQL dump that I would like to load/import in
postgreSQL... I didn't try yet but I wonder if it's straightforward and
just import the mySQL dump into postgreSQL ?
(Of course, I want to migrate PHPBB running on a server with mySQL to
another server running with postgreS
an int8... you'll want to adjust the arguments of the
function appropriately for the actual datatype.
With my luck, somebody will respond with a "but postgres already has an
array_find-like function"... but if it does, I couldn't find it.
eric
---(e
o \d+? According to the
online help, the '+' is supposed to mean "more detail".
Alternatively, maybe a new command, \dr to list out only the
rules for the specified view (or table)?
Anyways, thanks for the hard work on 8.0. Can't wait for it to get out
of beta!
eric
Good evening,
I am rather new to the linux world and I am diving in head first.
I am trying to set up postgres with perl, python, and java support as I
am going to be developing applications in each to access the database.
I have used the following config string (which runs with out error)
LDF
us. A more generic
description of the position requirements including rate is listed below.
Please reply to [EMAIL PROTECTED] or to me directly.
Sincerely,
Eric Dahnke / Yamaha Music Interactive, Inc. / New York
t : 212 223 6272 / c : 347 524 1992 / f : 212 223 6261
The Database Analyst
[EMAIL PROTECTED] ("Scott Marlowe") wrote in message news:<[EMAIL PROTECTED]>...
> On Thu, 2004-06-17 at 23:03, Deepa K wrote:
> > Hi,
> > I am using Postgresql 7.1.3. PgSQL server gets shut down once the hard
> > disk space becomes full. Is thers any particular reason to shut down the
> > server
Hi,
I am just wondering if bytea functions (byteaeq, byteage,byteagt,...) will
be included in the offical document and assumed to be supported in future
release.
For now, I could only find them in release 7.2 note.
Your confirmation reply is appreciated.
Thanks!
Eric
ps.Is this the right place
ng Postgresql 7.4.2 on SUSE 8.4.
Any thoughts are greatly appreciated.
.
--
Eric Hillmuth
GIS Systems Developer
Vermont Agency of Natural Resources
802-241-3616
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ool idea.
In addition, some of our applications have a few background threads
that maintain persistent connections to the database. Being able to
logically label those processes would make it easier to identify which
backend processes are still connected.
eric
-
Am I living dangerously, or is this an "okay" thing to do?
eric
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
27;foo' as a quoted string against a
query in pg_class, so the above might make things clearer.
eric
ps, never knew about the "tableoid" field until just now. how
interesting.
I had hoped that this would create a single entry in my audit_log
table for each row updated. However, it
On Apr 7, 2004, at 12:43 AM, Joe Conway wrote:
Eric Ridge wrote:
On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:
And now you know why they are so good if you don't use all rows.
This benefit I think goes away if you use Joe Conway's suggestion of
WITH HOLD.
Okay, so WITH HOLD i
On Apr 7, 2004, at 7:51 AM, Jan Wieck wrote:
Eric Ridge wrote:
On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:
If the underlying query is for example a simple sequential scan,
then the result set is not materialized but every future fetch
operation will read directly from the base table. This
Using an OR or IN query seems to be orders of magnitudes slower than
running a query twice. There is an unique index on 'id' and an index on
'model_ns, model'. The number of row returned is less than 800.
Everything is vacuumed and analyzed. Running on 7.4.1. Perhaps this
situation is something the
?? Does it
charge on server basis or client basis??
Best Regards,
Eric Yum
CK Life Sciences Ltd.
Finance & Administration - IT
Team
Tel: 21261351
Hello.
After I have performed several queries by an external program on the
database, an error message appeared:
"hard limit on result handles reached is not a valid query result"
May I know how to solve the problem?
Thank you
---(end of broadcast)
ength parameter, and it uses a very different parameter passing
mechanism.
In the short term, we can work around the issue, but it would be nice to
be able to fix the problem. Any ideas are welcome.
Thank you.
Eric.
**
Eric Davies, M.Sc.
Barrodale Co
On Feb 25, 2004, at 9:07 PM, Joe Conway wrote:
Eric B.Ridge wrote:
I suppose this is obvious, but it's volatile because *other* backends
can change it while the current transaction is still in progress?
No. Other backends don't affect currval, but your own might on a
row-by-row basis
to
use in an indexscan constraint.
I suppose this is obvious, but it's volatile because *other* backends
can change it while the current transaction is still in progress?
eric
The subselect hack mentioned nearby fools the planner ... at the
moment.
I wouldn't guarantee that it will w
On Feb 12, 2004, at 12:08 PM, Bruce Momjian wrote:
Yes, I think that would be the only way to go, but I would like to have
some other folks interested in extending the ps display before adding
such a capability.
Too bad nobody responded. I still think it would be a useful feature.
eric
:
The built-in function "current_database()" returns the current database
name.
=# select current_database();
current_database
--
testing
(1 row)
Use it in your update statements too.
eric
UPDATE tblUpdates SET xxx=1234 WHERE pg_current = TRUE;
or
UPDATE tblUpdat
happy?
eric
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
.. OVERRIDE DEFAULTS to override ON UPDATE DEFAULT
values
and of course, this would be handy too:
UPDATE foo OVERRIDE DEFAULTS set d=DEFAULT;
eric
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www
;foo_seq'),
d timestamp DEFAULT now() ON UPDATE now()
);
But it seems that if the user explicitly provided a value for 'd',
you'd want to use that over the computed value.
Whatever the details, it would be a very useful feature to have.
eric
--
x27;t know if the difference in speed is
enough to convince one (myself included) to start using prepared
statements, but it's another data point.
But still, a real-world example might prove all of this wrong.
eric
---(end of broadcast)-
_
High-speed usersbe more efficient online with the new MSN Premium Internet
Software. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1
---(end of broadcast)---
TIP 4: Don't '
?
Can I go into the /data directory and find the file that contains that table
and delete that? If so, how would I go about doing this?
Eric
_
Expand your wine savvy and get some great new recipes at MSN W
Hi,
I'm using version 7.3.3. I do a lot of modification to some of the tables in my database. There's a table that I didn't run vacuum on for a while and I ran some big queries on it. It was taking a long time so I aborted the query and tried running a vacuum on the table. It ran for around 48 hou
ing material to help?
Thankyou
Eric Holmstrom
floating point numbers:
mysql> create table test(foo int);
Query OK, 0 rows affected (0.51 sec)
mysql> insert into test (foo) values (1.5);
Query OK, 1 row affected (0.42 sec)
mysql> select * from test;
+--+
| foo |
+--+
|2 |
+--+
1 row in set (0.01
e to trigger (because you haven't updated your code), the
back end will refuse to replace the function complaining of a mismatch
in return types.
eric
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
equiring a restart of the computer. On 10.1,
I couldn't even get it to change the shmmax value, necessitating some
very low buffer numbers (nearly out of the box for pg 7.2, yes, that
bad).
eric
---(end of broadcast)---
TIP 5: Have you checke
Does anyone know the exact definition of a Prepared Statement?
String sql = "SELECT count(id) FROM customer";
executeQuery(sql);
I assume the sql string is a prepared statement? Semantic debate here. -
Thx
---(end of broadcast)---
TIP
, SQL_ASCII and UNICODE, all failed.
These are my configure: RH9 + Postgresql 7.3.4 + Tomcat 4.1.24 + JSP. Do I need to update RH9 also?
Looking forward for you reply. Thank you very much.
Best Regards,
Eric Tan
「向左走 向右走」趣怪 VoiceMail 歡迎詞
http://voicemail.yahoo.com.hk
at 7.4 will win the footrace.
By no means is this official, cuz well, I ain't in the loop, but I
recently read something about mid-late November.
I suspect they'll want it out by the time all the G5's are shipped...
and the 2x2gig started shipping on friday...
if you execute 'select_gcc 3.1' as root it should change your default
GCC to a compiler that works.
That fixes the problems with -traditional-cpp v/s -no-cpp-precomp, but
it doesn't fix:
ld: Undefined symbol
_tas
eric
---(e
On Sep 27, 2003, at 3:43 PM, Tom Lane wrote:
Eric Ridge <[EMAIL PROTECTED]> writes:
I don't think the OS X 10.3 betas are readily available (I've payed to
be in Apple's developer program), so if you don't have access to 10.3
but have some idea as to what would cause this
the files that gcc complained about. There were a few
more than the above examples, but not too many.
too. It would be interesting to understand what the problem is.
There it is.
eric
---(end of broadcast)---
TIP 8: explain analyze is your friend
how could I fix this problem:
ERROR: unexpected chunk number 8 (expected 0)
for toast value 6935693
It appear to be simple: update chunk_seq from 8 to
0.
how to do it?
in the stand alone postgres, could I copy a entire
table?
how to do it?
tnx
Eric
sorry about dumb ´lenght´ instead ´length´.
the length of chunk_data is 255.
tnx.
Eric
- Original Message -
From: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
To: "PostgreSQL general" <[EMAIL PROTECTED]>
Sent: Friday, August 08, 2003 1:14 PM
Subject
he command was: COPY
"tbdmovimento" TO stdout;
pg_dump: *** aborted because of error
why can´t I simply update chunk_seq from 8 to 0?
tnx
- Original Message -
From: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
To: "PostgreSQL general" <[EMAIL
Sure thing, I'll get subscribed to -bugs and send it!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Sent: Friday, August 01, 2003 11:06 PM
To: Eric Johnson
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Using contrib/fulltext on multiple t
ve tried breaking it into two scripts (one for db structure and one for
test data) but it still doesn't do the indexing on c.
Any Ideas?
I apologize for the length,
Eric
---(end of broadcast)---
TIP 2: you can get off all lists at once with th
like what I have seen of PostgreSQL.
Thanks,
Eric
At 10:19 PM 6/22/03 -0400, Tom Lane wrote:
>Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Interesting thread (php-dev subj: removing bundled libmysql):
>> http://marc.theaimsgroup.com/?l=php-dev&m=105621066832429&w
ansaction yet
end
v/s
SELECT word_id FROM words WHERE word='foo';
if (resultset size == 0)
INSERT INTO words (word) VALUES ('foo');
end
eric
---(end of broadcast)---
TIP 2: you can get
What else should we do?
Eric Nielsen
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
27;ve tried re-configuring with a
--with-includes=/path/to/python/include, but we still get the same error.
(Python hsa been installed and works.) Any help would be appreciated.
Eric Nielsen
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if po
.php?queries.html#QUERIES-GROUP
and creating an index on job_num might improve performace even more, but
I don't know if index scans are used in aggregate functions or not.
eric
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
htt
Does anyone know of some good open source applications that are using
postgresql well? I am interested in studying schema and physical design
of some well thought out applications. Any suggestions would be
helpful.
thanks,
eric
---(end of broadcast
'city_type' that has a value of 'capital'?
Suppose I had another table river_cities and what I would want to be
able to is SELECT * FROM cities and know whether the city was a
river_city, capital, or nothing at all.
thanks,
--eric
---(end of broadcast)-
http://www.internetweek.com/reviews01/rev090301.htm
I would be most interested to here this lists response to the following
paragraph. Though much of the specifics of the benchmark are left out,
so tuning could very much of been an issue.
Database performance is a key issue for most busines
ables of the relaionship. Does anyone have
suggestions along these lines on how to generalize such relationships?
thanks,
--eric
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
ystems things are going to be complicated,
whether you're tracking images or chickens. You've got to find the
solution that will give you the most long-term flexibility, even if that
means more complication.
eric
---(end of broadcast)---
T
is
more efficient than the Postgres network protocol. Plus, no need to
encode and constantly decode the bytes.
Also, if you're not going to be searching the bytes of the file (which
I'm sure you're not), why put it in the database?
eric
---(end of broadcast)-
") > 80);
I guess the second would fail on the alias, but the first should
succeed ??
I can't say anything about the specs, but the parser/planner/optimizer
would have to be able to fall back to applying the WHERE after the UNION
if it couldn't match up c
"UPDATE"
What obvious thing am I missing?
I just upgraded to postgres (7.1.??), I'm running Linux, and
everything else seems to be working (I can run JDBC queries, no
problem...)
Help!
Cheers,
Eric
---(end of broadcast)-
t sequence number used by the current process. This is why
currval() will generate an error in a new session if nextval() hasn't been
called for the given sequence.
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Wed, Jun 06, 2001 at 03:17:36AM +0200, Severin Olloz wrote:
> Hello...
>
> Why does Postgresql order the uppercase letters first?
Because all uppercase letters come before the lowercase letters. Maybe
"ORDER BY lower()" will work? This should also be locale
dependent ...
; /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling
> reading 5
> /usr/local/progs/pgsql/bin/postmaster: ServerLoop: handling
> reading 5
>
> What is status 139 ?
139 = 128 + 11 ; Sig 11 ?
--
Eric G. Miller <[EMAIL PROTECTED]>
-
, without restarting Apache, Apache will probably still
be referencing the earlier version of the php shared library. Files aren't
really deleted until their reference count goes to zero.
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Maybe you want to read the manual. Specifically look at
transaction isolation level under MVCC. Hmm, SET TRANSACTION ISOLATION
LEVEL doesn't seem to be taking in 7.1.1... Is that a bug? Guess the
only way to be sure is to use the transaction semantics above...
--
Eric G. Miller <[EMAIL PR
rst
and either export PGDATA or use the "-D /path/to/data" directive.
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [
..
You might want to use LOCK instead of FOR UPDATE since its behavior
depends on the TRANSACTION ISOLATION LEVEL.
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
NTO tb2_new (kd_lab, tb2, key)
SELECT kd_lab, tb2, key FROM tb2;
-- Stop if there was an error!
-- Don't drop unless you're sure the data got copied okay
DROP TABLE tb2;
DROP TABLE lab;
-- Rename tables
ALTER TABLE lab_new RENAME TO lab;
ALTER TABLE tb2_new
THANK YOU VERY MUCH
Maybe you want your function to iterate through the records and return a
string of concatenated results? Or does it need to be a tuple? To do
so, I think you'd need to use pgplsql.
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of bro
> REFERENCES target is not allowed.
>
> Short of creating another table which stores all product ids, is there a
> simple way to make this work?
Doesn't work with inheritance...
Do instead:
create table "products1" (
"product_id" NOT NULL REFERENCES "p
accessor functions though...
int4
SampleGetnCtr1 (Sam *s)
{
return s->nCtr1;
}
Etc...
Then, maybe, you can call the function(s) to get/set it's parts...
SELECT sample_get_ctr1(mysample) INTO foo FROM ... ;
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broa
do a commit or
rollback -- so be quick about it...
You might consider using a sequence if you can...
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
ING DELIMITERS '|';
{{1,2},{3,4}}
{{4,3},{2,1}}
\.
The level of nesting of braces "{}" indicates the dimensions of the
array. 1-dim {} , 2-dim {{},{}}, etc.
--
Eric G. Miller <[EMAIL PROTECTED]>
---(end of broadcast)-
On Sat, Mar 31, 2001 at 12:17:46AM -0600, will trillich wrote:
> On Fri, Mar 30, 2001 at 06:34:45PM -0800, Eric G. Miller wrote:
> > On Fri, Mar 30, 2001 at 06:40:13PM -0600, will trillich wrote:
> > > even using PLPGSQL, is it possible to send VARYING relation
> >
ing all of the
field names for the relation which you can compare to the concatenation
of your "field" and NEW.qty. Hope this is making some sense. Here's a
quick example query on a known relation called "units".
select pg_attribute.* from pg_attribute
id totally failed ALL his classes! And before someone
> > points it out, yes I saw the DBZ.
>
>
> dbz?
Division By Zero. Also, the above would perform integer division, would
need a cast to 'float8' on one of the operands.
--
Eric G. Miller <[EM
301 - 400 of 421 matches
Mail list logo
