On Fri, Jan 21, 2005 at 03:23:47PM -0200, Bruno Almeida do Lago wrote:
Any info about NetBSD?
That's all we use - no problems, so never had to do any comparisons..
Patrick
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
On Thu, May 13, 2004 at 11:41:24AM +0200, Christian Rank wrote:
create function f () returns void as '
begin
delete from a;
delete from b;
return;
end;
' language plpgsql;
I would expect that
select f();
yields an error message
On Fri, Oct 24, 2003 at 04:27:16PM -0700, [EMAIL PROTECTED] wrote:
...
ZRAN|2003-10-03|20031003| 731491| 20.25| 21.
(609398 rows)
pma= select * from stck_dta_tbl_oprtnl where stck_sym = 'ZRAN';
How about
pma= select * from stck_dta_tbl_oprtnl where stck_sym like
Is something up with gborg cvs, or have the settings changed?
% cvs update
cvs [update aborted]: connect to gborg.postgresql.org:2401 failed: Connection timed out
% cat CVS/Root
:pserver:[EMAIL PROTECTED]:/usr/local/cvsroot/libpqxx
% cat CVS/Repository
libpqxx
Cheers,
Patrick
On Thu, Jul 31, 2003 at 11:52:42AM +0800, Ryan F. Bayhonan wrote:
Hi Patrick,
Have read your reply in the web about postgreSQL.
(http://archives.postgresql.org/pgsql-interfaces/2001-01/msg00170.php)
My name is Ryan, and I would like to ask some help about PostgreSQL.
I have the
On Fri, Jul 25, 2003 at 04:13:12PM -0500, Ron Johnson wrote:
On Fri, 2003-07-25 at 15:02, Bruce Momjian wrote:
Does anyone use YY-MM-DD for date input?
Right now, it only works mostly for pre-2000 dates because we can detect
that 97-02-03 is a year, while we can not detect that in
On Wed, Jul 23, 2003 at 01:36:52PM -0400, [EMAIL PROTECTED] wrote:
Hi all,
I am trying to convert a timestamp field to a date. ('1993-08-10
17:48:41.074' to '1993-08-10').
I used date(TIMESTAMP_FIELD), but it seemed working only for date
after year 2000 and return the previous date
for
On Wed, Sep 19, 2001 at 11:34:56AM -0700, Stephan Szabo wrote:
Are there no rows with timesliced'01-May-2001'? I think in that
case sum() gives you one row with NULL.
Thank you for the clue! *slaps forehead*
transatlantic=# select min(stats_id),max(stats_id) from trans;
min | max
select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and (timeslicet '1:05' OR timeslicet '6:05')
returns a number (9188191930), whereas
select coalesce(sum(deltafromoctets),0)
from trans,stats
where stats_id=stats.id
and (timeslicet '1:05' OR
On Mon, May 21, 2001 at 10:32:37AM -0400, Frank Bax wrote:
I have a machine with OpenBSD 2.6 and PSQL 6.5.3 that allows the use of
up-arrow to retreive/edit previous commands.
I recently built a new machine with OpenBSD 2.8 and PSQL 7.0.2 (from
package) and this feature is GONE!
Is there
On Thu, May 10, 2001 at 02:08:56PM -0400, [EMAIL PROTECTED] wrote:
I have 7.1
Can someone take a look the following
and tell me why I'm getting errors?
I'm completely baffled!
what= create table bla(desc text,def text,data text);
ERROR: parser: parse error
On Thu, May 10, 2001 at 01:22:56PM +, [EMAIL PROTECTED] wrote:
I vacuum every half hour! Here is the output from EXPLAIN:
NOTICE: QUERY PLAN:
Seq Scan on pa_shopping_cart (cost=0.00..7237.94 rows=9420 width=296)
EXPLAIN
Thanks!
Then try
set enable_seqscan to off;
explain
On Tue, Mar 06, 2001 at 10:38:43AM -0500, Michael Fork wrote:
try starting psql with the -E option -- this displays all queries used
internally to the screen, i.e.:
Sorry, hadn't read this one before posting... Thanks to the "moderating" it'll
all be out of synch anyway but..
Patrick
create table vals (
x float,
y float
);
insert into vals values (2,4);
insert into vals values (2,2);
insert into vals values (2,1);
insert into vals values (2,0);
select x/y from vals where y0 and x/y1;
will give a divide by zero error as A=(y0) and B=(x/y1) can be evaluated in
any order (A
On Wed, Jan 31, 2001 at 09:43:50AM +0200, Ismail Tiryaki wrote:
Hi all,
I have joined this list newly, and I have some question this
question may be solved up to now
I wrote simple c source this is connect my postgresql database
but when I compile my source I see some
On Fri, Jan 19, 2001 at 10:22:42AM +0900, Tatsuo Ishii wrote:
...
ALso, you could use UNICODE(UTF-8). For upcomming 7.1, PostgreSQL will
provide automatic conversion between:
UTF-8 -- EUC-CN
UTF-8 -- EUC-TW
UTF-8 -- Big5
Out of interest, does --enable-recode do anything if you don't have
On Mon, Jan 22, 2001 at 07:04:51PM +0530, Anand Raman wrote:
hi guys
While trying to isnert data into a table using the \copy i am getting a
error which states Bad timestamp representation..
I am not sure why it is occuring..
Can some one point out what this mistake is ..
My datestyle is
On Wed, Jan 17, 2001 at 02:21:01PM +0100, Fausto Guzzetti wrote:
Hello,
I have what I think is a trivial problem. But I wasn't able to find a solution
in the FAQ or in the docs I have.
It has to do with case sensitivity. I am working with an application of
PostrreSQL (7.02) and PHP4.
On Sun, Jan 14, 2001 at 12:58:16PM -0500, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
The effect in terms of query execution speed is probably minimal. The
problem is that the executables get about 15% larger, which can lead to
longer load times, more memory usage, and
On Sun, Sep 17, 2000 at 12:50:26PM -0700, Stephan Szabo wrote:
If you always SELECT ... FOR UPDATE (in all transactions that access it),
then the second one will not see the DB state before the transaction is
started, because the row is locked and the second transaction won't be
able to get
On Sun, Sep 10, 2000 at 12:43:08AM -0400, Neil Conway wrote:
I'm having a bit of difficulty understanding the correct usage of
foreign keys (I've never used them before, excuse my ignorance).
Here's a situation where I'm trying to figure out how/if they
should be used:
One database has a
On Fri, Jul 14, 2000 at 12:33:20AM +0200, Peter Eisentraut wrote:
Patrick Welche writes:
.. of course for me it's in libedit:
% nm -g /usr/lib/libedit.a | grep using_history
028c T using_history
Is libedit readline compatible now?
On a NetBSD-1.5B/i386 box, according
What exactly is a "tuple"? One entire row of a table? Or one "line" of a
reply to a query? (I suspect it's the entire row of a table, but I have had
a case with text fields, where one field was updated with about 7k. All
selects would deal either with that field or the others. The first time the
On Thu, Mar 23, 2000 at 12:14:51PM -0600, Kevin Heflin wrote:
What's wrong with *just* the first select?
The first select only grabs projects which have subprojects assigned to
them. I'm trying to figure out how to also grab projects which have no
subprojects assigned to them yet.
Ah -
On Sat, Mar 18, 2000 at 09:34:37PM -0500, Chris Gokey wrote:
I was hoping that someone could help me optimize this query. This takes
FOREVER under PostgreSQL.
select distinct data_center, center_long from de_center where de_center.de_id
in ( SELECT distinct de_parameters.de_id FROM
On Fri, Feb 25, 2000 at 09:56:59AM -0600, [EMAIL PROTECTED] wrote:
do not use date, use datetime. why? it's sql92 standard (another
good reason: M$sql only has datetime :-). A lot of useful functions
only apply to datetime, not date.
On a side note: if I have a date d and a time t column,
Am I the only one who cannot vacuum a named table? (Does it make sense to
just vacuum a single table?)
regression= \h vacuum
Command: VACUUM
Description: Clean and analyze a Postgres database
Syntax:
VACUUM [ VERBOSE ] [ ANALYZE ] [ table ]
VACUUM [ VERBOSE ] ANALYZE [ table [ (column [, ...] )
List of databases
Database | Owner
+--
Newnham| prlw1
% psql Newnham
psql: connection to database "newnham" failed - FATAL 1: Database "newnham" does not
exist in the system catalog.
template1= \c 'Newnham'
FATAL 1: Database "newnham" does not exist in the
Someone posted a message here asking how you set the date style. We went
through
- environment variable PGDATESTYLE
- SET DateStyle TO
- the -e flag to the backend
but of course if you are using ISO it isn't necessary!! There is no
ambiguity in
test= create table tab (t datetime);
CREATE
Vegeta wrote:
Hi list,
Is it posible to read and write BLOBs to a PostgreSQL table using
the PostgreSQL ODBC driver?
Thanks in advance,
Guido Urdaneta
I think this is the bit you may need?
The type used in the driver is simply called "lo" and here is the
command used to
Kevin Heflin wrote:
If from the psql command line I use select current_timestamp it shows like
this:
1999-10-01 14:30:53-05
However if I insert into a datetime field, when I do a select it formats
it like so:
Sun Oct 03 10:00:00 1999 CDT
Is there a way I can retrieve the
In the following join:
select * from computer,ethernet where computer.ethernet=ethernet.id;
One of the instances of computer has no ethernet value. I thought
computer.ethernet=ethernet.id would just evaluate to false for this
instance, yet
pqReadData() -- backend closed the channel unexpectedly.
32 matches
Mail list logo