x27;t found?
Um, what's wrong with:
SELECT to_char(current_time, 'HH12:MI AM');
?
(See "Formatting Functions" under "Functions and Operators" in the
User's Guide)
-Josh Berkus
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Beth,
Oh, and you should take this sort of question to the new performance list:
[EMAIL PROTECTED]
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
oin the PGSQL-PERFORMANCE mailing list and post this question
there:
[EMAIL PROTECTED]
message: "subscribe"
-Josh Berkus
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
in far more depth than I want to here;
2) Explore the tree module in /contrib in your Postgresql source.
I understand from Joe Conway that in 7.3, you will have another choice,
as Postgres will offer support for Oracle's tree-like "IS CONNECTED BY"
expression.
Good luck!
-Josh Berkus
P.
s possible that
your "ON DELETE CASCADE" trigger got wiped out somehow.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Laurette,
> How is this possible? I've tried to reproduce this, but haven't been able
> to yet. This has happened to use several times.
Oh, forgot question 2:
SELECT version()?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(
e indexes would be dropped as well.
-Josh Berkus
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
David,
I'm sorry, you just don't seem to be at the "self-help" stage. I
strongly reccommend that you hire a database consultant to help you.
-Josh Berkus
DAVID KUCHARSKI <[EMAIL PROTECTED]> wrote:
> the result set of the view is 3628 lines. It would be
>
Keith,
> >>But EXISTS is an entirely different animal which is often faster
> >>... isn't that in the FAQ?
>
>
> There is no reference to EXISTS in the SELECT documentation??
>
> Is this explained somewhere else?
Hmmm found this using the Index for the online docs:
http://www.us.postgr
ict if I tried to drop & re-create in the same transaction)
without a VACUUM. If you're using 7.1.3, you should upgrade for this
reason.
-Josh Berkus
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
erface code):
"interval"(cast($term as varchar) || ' months')
This approach makes you do a little more work on the data entry end of
things, but speeds up querying considerably. Also, should your
company policy change in the future to permit contract terms in weeks
o
r(10) NOT NULL REFERENCES
phone_types(type)
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Peter,
> Is it possible to create a view using tables from two different
> postgresql
> servers?
No.
-Josh Berkus
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
ng, that is not a cursor, even though it serves the same
purpose.
I'm pretty sure it's static, but it would be easy to test ... why don't you
give it a try?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
e
> looking elsewhere than SQL to do this for me, such as php (this is for a
> web-based report)?
You cannot dynamically sum all columns through SQL. You would need to use a
procedural language to loop through the columns and create sum clauses for
each one.
--
-Josh Berkus
Aglio Databas
ably, the function and table spec is extremely dense; I'm
trying to set up a test case.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
x27;t ever see the extra records.
I just tried to set up a test case for this issue, based on much simpler
schema. Unfortunately, the bug is not reproduceable in this simple case.
Any suggestions on how to reproduce it without dumping you an enitre copy of
my *confidentia
uld
stick with your current schema and custom function.
-Josh Berkus
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Folks,
Sorry for cross-posting.
Somebody sent me a review of the German postgresql book to post at Techdocs.
I had a mail server accident, and lost the review and the e-mail address of
its writer.
Are you out there? Contact me, please.
--
-Josh Berkus
Aglio Database Solutions
San
of OODBMS in another couple of years. Who
knows, ANSI might codify OODB-UML as a standard, and then we'll have
something to build on. But until then ... the RDBMS model has been
around for 32 years, and the SQL standard for 20, and that a lot of
accumulated wisdom to throw away casually.
-Josh Berkus
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
> The application is written in Java, by the way.
You should store this data in a sub-table linked through a foriegn key.
Period. Messing with arrays will only lead you to heartache ...
Try the book "Database Design For Mere Mortals" for a primer on SQL DB design.
) However, custom aggregates are slow and
Java's array-handling is probably faster.
-Josh Berkus
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ed on a view:
http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/rules.html
BTW, you can increase the number of parameters accepted by functions by
re-compiling postgres. Also, 7.3 will have 32 as the default.
-Josh Berkus
---(end of broadcast)---
Jim,
> Do any existing drivers / database version combinations support the
> isAutoIncrement method?
What programming language are you referring to? VB? Delphi?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of bro
ROTECTED] You
are unlikely to get an answer on this list.
-Josh Berkus
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Erwin,
> I read your FAQ: Working with Dates and Times in PostgreSQL with
> interest
> and was wondering if somebody came up with those datediff and dateadd
> functions?
> I couldn't find any at techdocs.postgresql.org.
I know somebody worked on one. I take it you read the articles on SQL
Server
Erwin,
> Thanks for your quick response Josh.
>
> I wasn't aware of the Postgresql-function DATEDIFF()
> The accolade ' is not a problem of course!
Whoops! Didn't want to confuse you. What I meant was, a PgSQL
function "Datediff" could be easily *written*, except that it would
need quoted id
thought that I could do this through a MAX(boolean), but as it turns out,
MAX(boolean) has not been defined in the standard 7.2.3. distro. I could
define MAX(boolean), but I'm wondering if I'm missing something obvious.
--
-Josh Berkus
Aglio Database Solutions
San
d get added to the core? I
don't see any good reason not to have one.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
esting,
SELECT true = ANY ( SELECT boolcol FROM complex query )
Is marginlly faster than
SELECT max(boolcol) FROM complex query
With a custom MAX(boolean) function.
So I'll stick to ANY().
-Josh
__AGLIO DATABASE SOLUTIONS___
tive.
>
> I wonder if I can find a standalone java query analyzer package. Does
> anyone know?
I believe that Red Hat offers the query analyzer as a download. Check their
site.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---
.x
clusters.
===
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
T INTO "VisitorPointer839" ("VisitorID")
SELECT "VisitorID" FROM (
SELECT DISTINCT ON ("VisitorID") "VisitorID","Type"
FROM "ProgramEvent" WHERE "ProgramID" = 10
ORDER BY "VisitorID",&q
s of
ANSI SQL.
> And Just writing it out straight.
>
> insert into VisitorPointer839 ("VisitorID")
> select VisitorID
> from ProgramEvent
> Where ProgramID = 10
> and Type = 0
> group by VisitorID
This just gives him a list of all VisitorIDs with a Type = 0, most recent or
not.
> Thanks
> Chad "I wanna be Josh when i grow up" Thompson
Thanks. But heck, I'm only 32! I'm not grown up yet!
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Of course,
it could be solved with a DAY/WEEK subtype, but I've already advocated for
that.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropria
t string. Potentially slower than #1, but easier to implement.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Thomas,
> > DBVisualizer is pretty good.
>
> Is there a page at PostgreSQL.org where all these links are listed?
> I've been saving each bit of mail that goes by on this thread...but
> a page on Pg would be very nice. ;-)
I was planning on writing an article; so far, I have a list of about 14
i
res lets you slack on this, but it would be worth trying
to see whether that has an effect on the problem.
Another thing to try is, instead of a simple variable assignment,
SELECT current_row INTO previous_row;
... and see if that works. I'll tinker later today; there has to be a
way
a few more tools to look at. Boy, do we have an
answer for the folks who complain "there are no GUI tools for Postgres".
I'll also have Justin update his list on Techdocs when I write my article.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
-
Chris,
> FOR this_record IN
> EXECUTE ''SELECT ''
> || quote_ident($1)
> || ''FROM ''
> || quote_ident($2)
> LOOP
> list := list || '', '' || this_record.$1 ;
> END LOOP;
>
> As expected, accessing a field via this_record.$1
> does not work.
> Can it be done otherwise?
Functions has been addressed in 7.3. However, I
am not sure about permissions for updatable views. Tom, Bruce?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unreg
Robert,
> If the functions can fire as there creator instead of there caller,
> then
> I would think as long as the creator has insert/update views on the
> base
> table, you should be able to do updateable rules and give only
> permissions to the view for the caller. (Though maybe you have to use
th your configuration of Oracle import. See your
Oracle documentation; we cannot help you here.
-Josh Berkus
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
s in "SQL for Smarties". I will write
a PostgreSQL implementation in a later article.
-Josh Berkus
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
# where user_id = OLD.user_id;
See the online docs, under Server Programming, for how to use the RULES
system.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
he view
4) A copy of your database session where your update is denied,
including the exact error message received.
Without that information, no futher help is available.
-Josh Berkus
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
vailable. Production
> for us is next spring, so maybe we'll be okay on this one.
> This approach would certainly allow our development team to
> right their code one way.
7.3 final is expected before December.
--
-Josh Berkus
---(end of broa
Luis,
> There's any way to insert data inside the tables, using the
> functions, called by the rules, without giving direct access to the
> user ?
> I don't know, using a trigger or any kind of structure !!??
Not until 7.3. Which is due out soon ... a couple of weeks,
Pedro,
> I´m looking for the name of the table that contains all databases in my
system. I already see this in the postgre manual, but i´m forgot where
pg_database
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadc
Jean-Luc,
> While we are on the subject,
> is there any ERD of the system's table somewhere?
Don't know ... but the system tables are about to change in 7.3.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
someone else will respond to your message as well. I'll
re-phrase one of your questions for the Hackers list:
QUESTION: Is there any way we could distinguish between literals and
column references when processing operators? That is, while we would
*not* want to implicitly convert a
r database to file. Backup. Edit the file.
Re-create and re-load the database.
-Josh Berkus
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Alex,
> On postgres 7.2.3 I have found what follows:
>
> explain select * from documents where iddoc>1;
>
> Seq Scan on lotti (cost=0.00..831.79 rows=26783 width=98)
>
> EXPLAIN
> explain select * from documents where iddoc=1;
>
> Index Scan using lotti_pkey on lotti (cost=0.00..2.26 rows=1
tgreSQL 7.3, as a /contrib module, by Joe Conway.
Download 7.3b5 now if you can't wait; Joe would like more people to
test his module, anyway.
-Josh Berkus
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
ent, open ridicule, most welcome. thanks.
This is a fine implementation using the adjacency list model of tree
design. However, I think you may find that the string-based tree
implementation in /contrib/ltree is more suited to your purposes, and
easier to maintain.
-Josh Berkus
--
the screen.
Can you break down, in more detail, what you're *trying* to do? It
can probably be done, but I'm still not clear on what you're
attempting.
-Josh Berkus
---(end of broadcast)---
TIP 2: you can get off all lists at once
return values to
the calling interface.
Now, what you could do is replace the whole insert with a function, doing:
SELECT add_cust( name, address, phone, credit_card);
Which does the inserting and returns the new id to the client.This is a
solution I frequently use in my web apps.
-Josh Be
le to hold the pathnames should cure your
"cascading trigger" problem.
-Josh Berkus
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
x27;d want to use Triggers or Constraints
etc.
There are, IMHO, some things Rules are better for, and some things Triggers
are better for. I tend to use all Triggers except for updatable views,
simply because using a mix of Rules and Triggers can be very hard to keep
track of, but YMMV.
--
h a table
check on
> > the new data impractical, so you'd want to use Triggers or Constraints
>
> We have changed ordering in 7.3 where I think INSERT rules are _after_
> the insert.
How would that work? What if I want to reject the insert?
--
-Josh Berkus
Aglio Database S
ion
if necessary, otherwise inserts. It's tricky, but probably the best way to
get trigger + rule functionality at once.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: if posting/reading through U
will see if RECORD works too. I wonder if that would eliminate the problem I
ran into where I had dropped and recreated the table. The function barfed
since the OID for the user defined type "test" did not exist.
>
> This will work slick. Thanks!
>
> >>&g
n 7.4 devel by accident.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(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
se post your table definitions as SQL statements.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
W. You're also missing the parts
of a PLPGSQL procedure. What you want is:
create function pr_tr_i_nodes() returns opaque
> as '
DECLARE v_ancestor INT;
BEGIN
SELECT ancestor_id INTO v_ancestor
FROM ancestors WHERE ancestors.node_id = NEW.parent_id;
INSERT INTO ancestors
VALUES ( NEW.no
atement is a much better than a RAISE EXCEPTION
> statement?
Not that I have encountered, but YMMV.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregi
; from the aforementioned
> SELECT, leaving the non-coincident dates in blank and filling the rain data
> of the coincident dates. Is this possible? How?
I don't think this is the best method to find missing dates. However, I'm a
little confused as to what you consider a "mis
Prashanth,
> I am working in the database area for the first time.
> My work is related to Postgres. Now comparatively i am familiar with
> the Postgres.
> I am looking for any document on differences between postgres and
> oracle w.r.t SQL syntax and built-in functions.
> Any pointers in this dir
Tim,
> That loop apparently does not find any matching rows, which would
> have been inserted just before this row was, inside the same
> transaction.
>
> It was successfully finding those rows before, when the trigger was
> AFTER INSERT. If I manually select those rows after the query is
> commi
#x27;ve found pgAdminII to be sluggish on
a large, busy network because MS-ODBC is quite vulnerable to traffic
conflicts. And phpPgAdmin, at least several versions ago, had a
tendency to issue a seperate query for each single bit of information,
mySQL-style (they may have fixed
Chad,
> I am trying to come up with an efficient table design
> that describes a fantasy character that meets the
> following criteria:
Believe it or not, this is the first "D&D" question I've seen on
this list.
> CREATE TABLE ATTRIBUTES (
> CHAR_ID INT PRIMARY KEY NOT NULL,
> ATTR
Dave,
A trigger function does not take variable parameters, gets its data
from the NEW or OLD records, and returns OPAQUE with the RETURN NEW
statement.
Please check out the documentation on writing PL/pgSQL triggers under
Procedural Languages in the online docs.
-Josh Berkus
procedural logic for a dynamic set of
parameters. However, the above is set up for numeric values (i.e. one
multiplies the grid number by the value to add into calculations) and
will not work for your varchar-returning query.
You could, however, constuct the grid with NULLs and '' str
Richard,
> I'm confused. How do I get the integer 10102 to come in as the date
> 2002-01-01?
Hmmm ... isn't this an old post, repeating?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP
r by user_login.last_login desc;
Use a "WHERE EXISTS" clause instead of "IN".
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Th,
> > I have performance problem of an request of type ... WHERE ... IN (
> ... ).
> > How to improve performance of this type of request when a group of
> id in the
> > 'in' is important.
>
> Try WHERE ... EXISTS (...).
The explanation of the difference btw. IN and EXISTS is in the
PostgreSQL
database, and if it's a low-budget project
destined to be thrown away in 3 months, then go for it. If, however,
you expect this database to be around for a while, you owe it to
yourself and your co-workers to design it right.
If you want an education on database normalization, pi
E FUNCTION to_year (timestamp) RETURNS varchar AS
'SELECT to_char($1, '''');'
LANGUAGE 'sql' WITH (ISCACHABLE, ISSTRICT)
(above is 7.2.3 syntax)
Then use the to_year function in place of to_char for creating your
index.
-Josh Berkus
-
;' || $2
END
' LANGUAGE 'sql';
--create aggregate with html between items
CREATE AGGREGATE br_list ( BASETYPE = text, SFUNC = br_cat, STYPE = text,
INITCOND = '' );
--create aggregate with commas between items
CREATE AGGREGATE comma_list ( BASETYPE = text, SFUNC = comma_cat, STYPE =
text,
INITCOND = '' );
-Josh Berkus
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
HERE NOT (co_id=1 OR co_id=2 OR co_id=null OR co_id=3...)
> WHERE NOT (... OR null OR ...)
> WHERE NOT (null)
> WHERE null
I'd suggest that you do not want to give readers an example that contains NOT
IN (subselect). There are almost no cricumstances under
after the "Database Design
> For Mere Mortals". I will read the book.
That's a great book, too. Don't start on Pascal until *after* you
have finished "database design".
-Josh Berkus
---(end of broadcast)-
> I waited for the book from the local library for more than a month, but only
took me less than a hour to scan over the
> whole book and grip the multivalued table design idea.
Hmmm. I'll need to look at it again. If he's suggesting that it's a good
idea to put a delimite
nd
additionally allow for the promotion of "peripheral" docs to the core easily.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subsc
Wei,
> I want to select some data out of database A, and insert them into database
B. Is it possible to do in one SQL query?
>
No. Use a Perl script.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
t confused by your question. Could you try explaining it another way,
possibly with SQL code examples?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
, you would have to
set a tuple lock with something longer lasting than select for update, and
arrange to drop it if the connection dies. but it's still my preferred
solution)
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
in an aggregate function. Should a
> change be made to the error text?
Nope. The error message is exactly correct. If you didn't want to GROUP BY
jobno, then what you actually wanted to query was:
SELECT count(jobno) FROM drawing_register;
--
-Josh Berkus
Aglio D
Moritz,
There is a performance mailing list at:
[EMAIL PROTECTED]
--Josh
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Moritz,
> I'm sorry, I didn't realize this, it is certainly closer to what I
> need.
> Next time I'll look better (google brought up references to this
> list, so
> I subscribed here).
Hey, there are 18 active lists now ... we don't expect anyone to get
the
David,
> Are there functions for adding and subtracting this type from itself?
> Or is there a simple way to do it?
The MONEY type is depreciated, and should have been removed from the Postgres
source but was missed as an oversight. Use NUMERIC instead.
--
-Josh Berkus
Aglio Da
Ricardo,
For future notice, there is another mailing list, PGSQL-PERFORMANCE,
devoted to questions like yours.
> select * from llamada where fecha='20030127' and tipo=1 and tiempo>0
> and gwdes like '64.7.127.14%' order by hora desc;
>
> It's very slow, it takes approximately 6 minutes to show m
David,
> I have a function that is to create a Accounting JOURNAL entry.
> The strange thing is the function works for simple entries such as:
> Here is the function and I can't seem to figure out what is LOGICALLY
> wrong and would produce these results.
I'm not sure the problem is with the fun
David,
> Cash - Debit 100
> A/R - Credit 100
> Cash - Credit 100
> A/R - Debit 100
> (Which should have a net affect of 0 on both accounts)
>
> But here is the resulting balance on accounts,
>
> Cash Debit Balance 200
> A/R Credit Balance 200
Here may your problem, and it's in the schema
y exploits and one backup-and-restore bug that could make it difficult
to recover your database from a backup file.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
Vicente,
> if I try nodo_fecha_activ<= 104422680 then it gives me this error
> ERROR: Unable to identify an operator '<=' for types 'numeric' and
> 'double precision'
This is a known problem that will be fixed in a later version of
Postgres. For now, you have to cast.
-Josh
. However, implementation is
quite cumbersome, and I won't try to detail it here, particularly since that
language and method have been obsolesced and would force you to re-write your
code when you do upgrade.
If this feature is important to you, I strongly recommend that you upgrade to
7.3.1 now.
date a ficticious "totals" table with the sum of credits and
debits for a particular account.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
://www.globecom.se/tora/) functions as a
PL/pgSQL editor if you have the Oracle PL/SQL libraries installed. I haven't
tried this, myself.
I use KDE's Kate.
Good luck!
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)-
s its elements to a comma-delimited TEXT
variable.
2) Build up your query as a dynamic string.
3) Do your query loop as a FOR record IN EXECUTE dynamic_query_string
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP
Chester,
> sorry about this - braindead and cannot find in doc. what's pg's
> rownum pseudo-column or function name that returns the record number of
> a set?
There isn't one, unless there's something in /contrib that you can build.
--
Josh Berkus
Aglio Dat
501 - 600 of 838 matches
Mail list logo