Hi,
I have table named user (lower case) in public schema.
I can access it using Pgadmin as
SELECT * from "user"; SELECT * from "public.user"; SELECT * FROM public.user;
I can't find any way to access this table from Jdbc.
Tried to access as public.user, user in single and double quotes, nothing
Don't help either.
Jdbc statement:
SELECT * from "public"."user" ;
Exception:
ERROR: relation "public.user" does not exist
On Tue, May 12, 2009 at 5:55 PM, Scott Marlowe wrote:
> On Tue, May 12, 2009 at 1:26 AM, Joe Kramer wrote:
>> Hi,
>>
and fix
something I've missed.
Thanks all,
Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Tom Lane wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:
Can concurrent updates/deletes slow down vacuum when it is progressing ? I
mean to ask if vacuum would have to redo or stall its work because of the
updates/deletes. Is it even possible that it goes into a long loop while
such u
After a create or replace view, the new view definition is not being
used by plpgsql functions that use the view. Is this a known bug ? Is
there a workaround it ?
For instance, selecting from afunc() still returns the old view's results.
create table c ( a int );
create or replace view a as select
else has tricks/plugins for
emacs users.
I have used sql-postgres mode in the past, under both emacs and xemacs.
It is quite good. Haven't got it working currently under windows, I
think I need to tell it where i have a psql binary.
Joe
---(end of broa
Joe Healy wrote:
Sean Davis wrote:
This is a bit off-topic
Does anyone know of an interface between emacs and psql? I currently
use it as my default editor and do my share of save and then \i. I
just gave pgEdit a try and liked many aspects of it, but I still like
Emacs as an editor and
Tom Lane wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:
After a create or replace view, the new view definition is not being
used by plpgsql functions that use the view. Is this a known bug ? Is
there a workaround it ?
Start a fresh backend session. The old query plan is pres
nheritance for DIY table
partitioning on very expensive storage hardware (~$500K), and we'd be
dead in the water without it.
Joe
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello,
After a VACUUM FULL I saw that pg_attribute tables indexes haven't
been deleted as reported by a subsequent vacuum analyze. But the pages
corresponding to just the table has been deleted to 196 pages from
about 181557 pages. Are all system tables affected by this ? How can
we reclaim thi
2 pages
DETAIL: 114 dead row versions cannot be removed yet.
There were 2546542 unused item pointers.
0 pages are entirely empty.
CPU 0.32s/0.28u sec elapsed 0.67 sec.
INFO: analyzing "pg_catalog.pg_class"
INFO: "pg_class": 49182 pages, 1290 rows sampled, 1290 estimated total rows
VACUUM
-Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
There is a .NET data provider that I know of but its not specific to DNN in any way. It can be used in any .NET project
http://gborg.postgresql.org/project/npgsql/projdisplay.php
Best Regards,
Joe AudetteRandy How <[EMAIL PROTECTED]> wrote:
Our company is moving toward developi
't my problem, so it falls on Joe and
Thomas to get up to speed on what I've been doing and do likewise.
Is that really a win?
So far we've been able to keep up with PostgreSQL changes because a) the
interfaces are after all pretty well defined, and b) there is always a
long
ou need to assign the result of array_append() to a variable. It
doesn't change v_query_array in place.
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTE
ta to be
able to optimize performance and still have some fault tolerance.
-Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
//www.reportlab.org/rl_toolkit.html)
very easy to create pdf reports based on queries.
Hope this helps,
Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
are these 2 sets of messages related and second what would
cause either or both sets of messages to appear in the log?
Appreciate any help :)
-Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Tom Lane wrote:
>Joe Maldonado <[EMAIL PROTECTED]> writes:
>
>
>>I have these messages on my 7.4.7 database log...
>>TopMemoryContext: 87494704 total in 10676 blocks; 179400 free (61
>>chunks); 87315304 used
>>TopTransactionContext: 57344 total in 3 bl
http://archives.postgresql.org/pgsql-general/2004-08/msg00972.php
This bug appears to be fixed in Tiger (Mac OS 10.4). That's great, if
it's really true. Can anyone confirm?
---(end of broadcast)---
TIP 7: don't forget to increase your free space m
least familiar to me but I am trying to
learn.
Any help much appreciated.
Joe Audette
joe_audette [at] yahoo dotcom
http://www.joeaudette.com
http://www.mojoportal.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Devrim GUNDUZ wrote:
Our FC2 x86_64 bit FC2 packager (Joe Conway) is on a long trip; I'm not sure
that we will be able to prepare RPMs for that arch/distro right now :(
I got back finally last night, and I'm just now at 9 days behind in
reading the list traffic, but I should
Joe Conway wrote:
I got back finally last night, and I'm just now at 9 days behind in
reading the list traffic, but I should be able to build x86_64 FC3
RPMs in the next day or two (unless someone has beat me to it).
Unfortunately I no longer have an x86_64 FC2 machine available t
of a really good way to do that directly in Postgres, but
I'd bet (still not sure though) there is a way in R.
http://www.r-project.org/index.html
If so, you could use PL/R:
http://www.joeconway.com/plr/
HTH,
Joe
---(end of broadcast)---
k
2005-04-21 22:30:47 [21315] ERROR: current transaction is aborted,
commands ignored until end of transac
tion block
we're suspecting pg_autovacuum as being the culprit but cannot nail it
down quite yet.
-Joe
>
>
>>followed by about 16GB of the following type of entries...
>
t Search
capability is based on MySQL's full-text search functionality [SELECT ... WHERE
MATCH (...) AGAINST (... IN BOOLEAN MODE)] . PostgreSQL doesn't appear to have
something resembling that. I'm curious as to third-party solutions or
development plans.
Joe
on that table, and on all the indexes on any tables referenced by
foreign keys. OS and Version info below, more info available upon
request. Does anyone have any suggestions on how to fix this?
Thanks,
Joe
select version();
On Wed, 2005-07-06 at 11:20 -0400, Tom Lane wrote:
> Joe Markwardt <[EMAIL PROTECTED]> writes:
> > I am getting this error "ERROR: cache lookup failed for relation
> > 438095645" when i try to run "drop table
> > pl_inventory_analyzer_files_table ;&qu
On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote:
> Joe Markwardt <[EMAIL PROTECTED]> writes:
> >>> I am getting this error "ERROR: cache lookup failed for relation
> >>> 438095645" when i try to run "drop table
> >>> pl_invent
On Wed, 2005-07-06 at 23:36 -0400, Tom Lane wrote:
> Joe Markwardt <[EMAIL PROTECTED]> writes:
> > On Wed, 2005-07-06 at 14:04 -0400, Tom Lane wrote:
> >> They appear to be triggers for a foreign-key constraint between
> >> pl_inventory_analyzer_files_table and
Hi
apache test page is showing at 2005-07-15 09:00 AEST.
Joe.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
transactions to finish before truncating the table
thus blocking all other operations.
Is this what is actually going on or am I missing something else? and is
there a way to prevent this condition from happening?
Thanks in advance,
- Joe Maldonado
---(end of broadcast
Thanks...I just wanted to verify that it was the intended behaviour
prior to going in and changing code :)
- Joe Maldonado
Tom Lane wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:
It seems that TRUNCATE is first posting a lock on the table and then
waiting for other transacti
SELECT in the FROM
clause which in turn is joining with a view that contains the table
which TRUNCATE is being executed against.
Is it possible that the SELECT was issues just before the TRUNCATE
statement was issues and the view in the sub SELECT was waiting on
TRUNCATE's lock?
Tom Lane wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:
While researching this locking issue I got some of the logs and found
that in one of the cases there was a SELECT running for a long time,
about 2 hours. This select statement does not usually take more than a
few seconds
tely far removed from the operation your rule is firing
for.
When it was added (and discussed on the lists) it was also acknowledged
that it would not be useful in all situations. However, there was at
least one use case where it worked as intended and needed.
Joe
---(
ual time=0.002..0.002 rows=0 loops=1)
One-Time Filter: NULL::boolean
-> Seq Scan
on test (cost=1.00..10020.38 rows=826 width=0) (never
executed)
Filter: (("key")::text <> 'something'::text)
Total runtime: 0.110 ms
(6 rows)
-- Joe Maldonado
+---
Bill | {1,1,1,1} |
{{meeting,lunch},{training,presentation}}
(1 row)
Care to provide some more info? What version of Postgres are you using,
what is the exact SQL that is failing, and what is the error message
you
mp WHERE 1 >= ALL (pay_by_quarter);
You are asking for matches where 1 is greater than or equal to all
the elements in the array. In Carol's case 1 is less than all the
elements -- hence no match.
Joe
---(end of broadcast)--
ou all the necesarry information.
I will have several RHEL 4 servers by early November, and will be
building RPMs for them. I'll let you know when I have RPMs ready.
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive
given the aggressive nature of the statement it is not something
I want to do on a high transaction db unless I absolutely must.
Thanks in advance,
--
Joe Maldonado
OUPUT:
db=# vacuum verbose test_table;
INFO: vacuuming "public.test_table"
INFO: "test_table": removed 13
nt_setting
---
/usr/local/pgsql-8.0/data
(1 row)
Joe
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
field types don't exactly match? (i.e. int vs int[])
A trigger perhaps?
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
;
return;
end;
$$ language plpgsql;
regression=# select testfoo_func(id) from testfoo;
testfoo_func
--
(2 rows)
regression=# select * from testfoo_det;
id | elem
+--
1 | AA
1 | BB
1 | CC
1 | DD
2 | EE
2 | FF
2 | GG
2 | HH
(8 rows)
HTH,
Joe
---
bar_id | array_accum
+-
1 | {alpha,bravo,charlie,delta}
2 | {A,B,C,D}
(2 rows)
HTH,
Joe
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Is there a recommended "postgres way" to determine if a certain row is
locked... without blocking?
In my custom postgres client app I'd like to be able to determine if
another user is "modifying" a given record. If so, I would present a
dialog to the user such as "Record Locked. Sam Smith is a
ck would help any in this circumstance... and I don't want
to resort to table locks for performance reasons.
On Nov 8, 2005, at 10:14 AM, Tom Lane wrote:
Joe Lester <[EMAIL PROTECTED]> writes:
In my custom postgres client app I'd like to be able to determine if
another user is &
Berend Tober wrote:
I'm stuck on not knowing how to define a
aggregate that takes more that one variable as its argument
This is currently unsupported.
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
ld that work for you?
select trim('\\000'::bytea from '\\00012\\00034\\000\\000'::bytea);
btrim
--
12\00034
(1 row)
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
r than
7.3).
My question is now wether the result is returned linewise in an newer
version
I'm afraid not. But are you sure you need pipelining?
Joe
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Thank you for Mac OSX Universal support at last ! Now the last PowerPc
application is gone Universal on my Mac.
Pgadmin now 4 times faster as Universal on Intel!
Thanks for your great work!
On 9/14/06, Dave Page wrote:
I'm pleased to announce the first beta version of pgAdmin III v1.6.0 is
ava
ing veraid = 2 and veraid = 34
might help.
While the query is running, how much CPU is the process consuming, and
what does vmstat show for disk and swap I/O?
Joe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore yo
nning, how much CPU is the process consuming, and
what does vmstat show for disk and swap I/O?
~80% CPU power. Disk usage is not noticable.
Can you attach with a debugger and see exactly what's going on? If not
we'd need that self contained test case to rep
Pgsql 8.1.4.
I want return custom type from function as row, not as values in brackets (1,2).
I have following type and function:
CREATE TYPE new_item_return_type AS
(item_id bigint,
last_update timestamp without time zone);
CREATE OR REPLACE FUNCTION new_item( new_title int8, new_user_id
Hello,
I have table for online chat system that keep messages sent between users.
CREATE TABLE chat_message
(
message_time timestamp without time zone NOT NULL DEFAULT now(),
message_body text,
user_id_from bigint,
user_id_to bigint,
CONSTRAINT chat_message_pkey PRIMARY KEY (message_time)
)
t projects.
What is the Right Thing for a guy who wants R to talk to postgresql?
I think you want this:
http://bioconductor.org/packages/1.9/bioc/html/RdbiPgSQL.html
The bioconductor project is now maintaining RdbiPgSQL. I think many
people also use RODBC to connect R with Postg
Reece Hart wrote:
On Tue, 2006-11-07 at 00:22 -0800, Joe Conway wrote:
I think you want this:
http://bioconductor.org/packages/1.9/bioc/html/RdbiPgSQL.html
The bioconductor project is now maintaining RdbiPgSQL. I think many
people also use RODBC to connect R with Postgres.
I almost sent you
need to
write another function to do this?
There is no support for this in connectby, but I imagine it wouldn't be
too hard to hack connectby to do it for you. Probably much easier to do
that than try to add it with another function.
Joe
---(end of broa
shion, use this:
http://www.joeconway.com/sessfunc.tar.gz
http://www.onlamp.com/pub/a/onlamp/2004/06/28/postgresql_extensions.html
HTH,
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
cussion on this topic:
http://archives.postgresql.org/pgsql-hackers/2003-06/msg01195.php
Unless we can convince ourselves that array-of-UNKNOWN is not dangerous,
I don't think this is easily solved.
Joe
---(end of broadcast)---
TIP 9: In ver
Quick question: I have installed PG 8.2.x on a customer's system and we will be
storing a lot of critical data on it. It needs to be backed up maybe twice a
day. It's very easy to back data up with the pgadmin tool (great tool btw) but
we need an automated solution that we can configure. This
mp;& (inside bounding box) is able to use the gist index, whilst the
exact contains is not able to.
Hope that helps,
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
, I tried to contact the author to see if he'd be willing to allow me
to pull out just the stuff I need and release it under a BSD license
along with my code, but he did not reply.
Joe
---(end of broadcast)---
TIP 4: Have you s
Use it like this:
select value from plr_environ() where name = 'MANPATH';
value
-------
/usr/local/pgsql-dev/man:
(1 row)
Joe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
Tk421 wrote:
I'm looking for a function that returns a md5 encryption for
postgreSQL 7.3.4
I've found that this function exists on version 7.4, but I have had
problems installing it on my Windows XP with Cygwin, so I need to
found it for version 7.3
See contrib/pgcrypt
ype is here the algorithm to use. E.g. 'md5', 'sha1', ...
Returns binary hash."
Joe
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hello all,
I have a few somewhat simple questions
Does the postmaster vacuum it's internal (pg_*) tables?
if not
what is the best way to vacuum them without having to vacuum the
entire db?
and how often is this recommended to be done?
Thanks,
-Joe
---(e
As promised, I've posted 8.0.0rc1 rpms here:
http://www.joeconway.com/postgresql-8.0.0rc/
Again note that these are not "official" PGDG rpms, just my own home brew.
In addition to the change of Postgres itself from beta5 to rc1, I
updated jdbc to latest beta (pg8
val1, (expandobj(obj)).val2, * from
mytable;
val1 | val2 | id | obj
--+--++-
x| y| 1 | x,y
(1 row)
HTH,
Joe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
into postgresql source ?
See:
http://www.postgresql.org/docs/current/static/runtime-config.html
and search for "preload_libraries"
HTH,
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if y
5 | 3
6 | 0
(6 rows)
BTW, as of 8.0.0, generate_series() is built in.
HTH,
Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
e sequence, lookup the local unique identifier from the
table defined in #1, and pass them both to the function defined in #2.
4. Use nextrowid('seq_name') to generate your primary keys.
HTH,
Joe
---(end of broadcast)---
TIP 9: the planner wil
u might be able to fake it with some C functions. See:
http://www.joeconway.com/myfunc.tgz
Look at myfunc_setvar(), myfunc_getvar(), and myfunc_rmvar().
HTH,
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
e end of the session. For arrays, it shouldn't be too terribly
difficult to extent the code to handle them.
Joe
---(end of broadcast)---
TIP 8: explain analyze is your friend
2. $0 is initialized to null and can be modified by the
function, so it can be used to hold the return value if desired,
though that is not required. $0 can also be given an alias."
http://www.postgresql.org/docs/7.4/interactive/plpgsql-declarations.html#PLPGSQL-DECLARATION-ALIASES
Joe
* search t
[EMAIL PROTECTED] wrote:
Aren't there any way to debug server programming functions (whatever the
language) ??
What's wrong with gdb?
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index sc
try putting an entry in the hosts file on
the slow machine to resolve the name of the db machine
and see if that helps.
I'm no expert on Postgre SQL so maybe there is a
driver difference or something that others on the list
would know better.
Hope that helps,
Joe
--- Quinton Lawson &l
://archives.postgresql.org/pgsql-general/2004-08/msg01017.php
HTH,
Joe
---(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
onths ago, but it has not seen
any activity yet.
Joe
On Feb 9, 2005, at 1:35 AM, John DeSoi wrote:
On Feb 9, 2005, at 10:39 AM, renato.barrios wrote:
Please tell me if Postgresql runns in an iMac.
Sure, assuming your iMac is running OS X. You'll need to install
Apple's free developer t
e docs back into the README if that's what you
want, but I split it up in the first place because it was getting very long.
Joe
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
e.net/
It should work with Postgres (as well as other JDBC datasources).
Microsoft is purportedly pushing MDX as a standard. Here's a discussion
of the MDX language:
http://mondrian.sourceforge.net/mdx.html
HTH,
Joe
---(end of broadcast)
inserting new rows, you should probably rethink
your data model.
Would it be more efficient to not use an array for this purpose but
split the table in two parts?
I think so.
Joe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
I'm happy to lump all the docs back into the README if that's what you
want, but I split it up in the first place because it was getting very long.
No, I'm not really proposing that we force all contrib modules
what might be happening? I'm at a loss.
Sounds like those two tables were created in the template database at
some point.
HTH,
Joe
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I installed from rpms after adding some sources to YaST based on this article
http://www.thejemreport.com/mambo/content/view/178/42/
Not sure its the absolute latest version of postgres.
Hope it helps,
Joe
joe_audette [at] yahoo dotcom
http://www.joeaudette.com
http://www.mojoportal.com
-01/msg00104.php
http://archives.postgresql.org/pgsql-general/2006-01/msg00108.php
Did you not receive those replies?
Joe
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
http://www.xtoss.org/
HTH,
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
stdin;" -h %s' % (dbname, user, table, host), "w")
for a in f:
unpackline = a[:-1].split(delimiter)
easting, northing, elevation = unpackline
process.write("SRID=%s;POINT(%s %s)\t%s\n" %( SRID, easting,
northing, elevation))
Hello,Pgcrypto SHA 256/384/512 algorithm don't work on RedHat:
db=# SELECT digest('test', 'sha1');
digest
--
\251J\217\345\314\261\233\246\034L\010s\323\221\351\207\230/\273\323
(1 row)
db=# SELECT
to compile
openSSL 0.9.8."
Pgcrypto depends on OpenSSL 0.9.8. And 0.9.8 is not "Stable" in RedHat
and Gentoo. So you need to recompile pgcrypto/openssl anyway if you
want to use it.
Can I report this in PostgreSQL bug system?
Regards.On 5/9/06, Marko Kreen <[EMAIL PROTECTED]&g
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> Thanks, but I need it to work out-of-the-box, with standard installation of> RedHat or Gentoo and standard PostgreSQL rpm.
>> I am developing application with PortgreSQL a
On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 5/9/06, Joe Kramer <[EMAIL PROTECTED]> wrote:> On 5/9/06, Marko Kreen <[EMAIL PROTECTED]> wrote:> > The fact that Fedora pgcrypto is linked with OpenSSL that does not
> > support SHA256 is not a bug, just a f
We've been using EMS PostgreSQL admin.Pros:It has great visual tools for building views. Like in Enterprise manager or MS Access. pgAdmin don't have that.Great import/export abilities. PGAdmin don't have much flexibility.
Cons:Too bad it don't support UNICODE and not known if it will.Problems with
Hello,
I need to grant all privileges on all objects in database. Without
using SUPERUSER.
It's strange that GRANT ALL PRIVILEGES ON DATABASE is useless, it
don't grant privileges on tables.
I've found out this "best practice", (more like ugly workaround):
select 'grant all on '||schemaname||'
/20/06, John DeSoi <[EMAIL PROTECTED]> wrote:
You can find some helpful grant scripts here:
http://pgedit.com/tip/postgresql/access_control_functions
On 5/19/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I need to grant all privileges on all objects in data
What the hell is Rupees?
On 5/29/06, AKHILESH GUPTA <[EMAIL PROTECTED]> wrote:
Hi there,
Help me by taking this survey. We can both get 1000 Rupees! Click here:
http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2
---(end of broadcast)--
replace view v1 with a different WHERE clause
create or replace view v1 as select * from t1 where 1 = 2;
HTH,
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
If it was commited to HEAD, it will appear in 8.1.5, right?
On 5/30/06, Bruce Momjian wrote:
Patch applied to CVS HEAD and 8.1.X. Thanks.
---
Marko Kreen wrote:
> On 5/9/06, Joe Kramer <[EMAIL PROTECTED]&
de/pgsql/server/test_func": No
such file or directory
Should 'usr/include/pgsql/server/test_func' actually be
'/usr/include/pgsql/server/test_func'?
Note the leading '/'
HTH,
Joe
---(end of broadcast)---
TIP 9: I
What does
ls -l /usr/include/pgsql/server/test.so
show?
Does the postgres user (or whomever postgres is running as) have the
ability to read the file?
Joe
---(end of broadcast)---
TIP 6: explain analyze is your friend
avior of
strict functions.) In any case the final function has the option of
returning a null value. For example, the final function for avg returns
null when it sees there were zero input rows."
HTH,
Joe
---(end of broadcast)---
TIP 5: don&
201 - 300 of 518 matches
Mail list logo