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 er
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 'ZR
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 r
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
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
>
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 timesl
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
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;
exp
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: pa
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 y>0 and x/y>1;
will give a divide by zero error as A=(y>0) and B=(x/y>1) can be evaluated in
any order
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 som
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
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
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
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,
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
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
On Thu, Aug 17, 2000 at 05:00:49PM +0800, Paul Juliano wrote:
> installing PL/pgSQL .. createlang: missing required argument PGLIB
> directory
I don't know about this one.
> Also, when I do:
>
> make runcheck
>
> the following message is in the postmaster.log
>
> IpcSemaphoreCreate: semget
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 c
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.
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
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
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 [, ...] )
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
> I then tried changing the btree index to a hash talbe and went through the
> same procedure of vacumming and restarting a psql session. Yet again, the
> index wasn't being used.
But did you try vacuum analyze or just vacuum?
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
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 retriev
I'm pretty sure someone already answered this, but the mail archive isn't
very searchable at the moment. How can you
if(update row fails because doesn't exist, ie. returns 0)then(insert row)
in SQL? Or am I misremembering and it was in some other language?
Cheers,
Patrick
(required C++ and libxbase
> C++ library).
>Distribution license: GPL
Oleg Broytmann wrote on 8 Apr 1999:
> On Thu, 8 Apr 1999, Patrick Welche wrote:
> > Is there a dbase3 <=> postgresql converter available at all? I found
> > dbf2sql v2.2 which converts to
Is there a dbase3 <=> postgresql converter available at all? I found
dbf2sql v2.2 which converts to (but not from) Postgres95, with notes such as
-p primary:
Select the primary key. You have to give the exact
field-name. (Only for dbf2msql, Postgres95 doesn't have a primary key)
which o
Is there some documentation on the macaddr type anywhere?
Cheers,
Patrick
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.
38 matches
Mail list logo
