We start a server and initiate 30 connections(with the libpq C interface)
which are stored in a stack to use and and to be reused.
After awhile I try to start another server that will also try to initiate 30
connections, for each connection I then get a PQErrorMessage like that :
"Sorry, too
On Tue, Mar 13, 2001 at 11:33:10AM -0500, Najm Hashmi wrote:
> We start a server and initiate 30 connections(with the libpq C interface)
> which are stored in a stack to use and and to be reused.
>
> After awhile I try to start another server that will also try to initiate 30
> connections, f
Hello -
It seems that using BETWEEN would work well, especially for finding
dates between two other dates.
WHERE date_date BETWEEN '03-02-2001'::date and '03-03-2001'::date
--d
> On Tue, 6 Mar 2001, Markus Fischer wrote:
>
> > Hello,
> >
> > I've a SELECT statement on many joined Tabled and
I cannot believe that PostgreSQL has a so poor document, I cannot found any
useful information. I afraid I have to select MySQL.
Does anybody know if PostgreSQL support Unicode and Full-Text Index? I
couldn't found any information about these from http://www.postgresql.org!
Thanks
Noodle
---
Hello,
do you happen to know, if there is any sqlserver that WON'T handle
inserting default value if it is not specified in the INSERT field list?
I am particularly interested in ORACLE, INFORMIX and MYSQL .
Eg.
CREATE TABLE test
(
id integer default 5,
fld1 text
);
INSERT INT
Hello:
I have a table with pluviometrical data
meteo (rain float, day date)
I want to select the the day of maximum value for each year.It should be
something like :
select max(rain),day from meteo group by date_part('year', day);
but it obiously doesn't work.
I thought of doing it with agg
Here's one approach:
create view vw_maxrain as select max(rain) as rain, date_part('year',day) as
year from meteo group by year;
select day, meteo.rain from meteo, vw_maxrain where
meteo.rain=vw_maxrain.rain;
"Salvador Mainé" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL
On Wed, 7 Mar 2001, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Boulat Khakimov wrote:
> >> ERROR: Can't find function encrypt in file /[full path here]/encrypt.so
>
> > Can _postgres_ user read /[full path here]/encrypt.so ?
>
> Presumably so. If he were unable to load the
David,
Please post your tabledefs and the full query definition. Aside from
the need for an explicit typecast (i.e. '2000-03-02'::date) and the lack
of clarity on month vs. day (March 2 or February 3?), seeing the whole
picture would help.
-Josh Berkus
__AGLIO DATABASE SOLUTIONS__
help me pls.
i got an error like this when i do an insert to a table, my table dont
have bpchar type of field.
ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
---(end of broad
Boulat Khakimov wrote:
> Hi,
>
> Im writing a C function for PG to do one way encryption using crypt.
> Here is the source code
>
> it gives me this error
>
> ERROR: Can't find function encrypt in file /[full path here]/encrypt.so
>
>
> Why do I get this error
> Any ideas?
Can _postg
Emils,
> do you happen to know, if there is any sqlserver that WON'T handle
> inserting default value if it is not specified in the INSERT field
> list?
> I am particularly interested in ORACLE, INFORMIX and MYSQL .
MS SQL 6.5, 7.0 and 2000 all support default values on incremental
fields ... w
Hello:
I have a table with pluviometrical data
meteo (rain float, day date, oid station)
I want to select the the day of maximum value for each year for a given
measurement station. It should look like :
select max(rain),day from meteo group by date_part('year', day) where
station=7654765;
th
Hi,
I installed postgresql 7.0 from RedHat CD. According to the official 7.0
doc, ecpg comes with the installation. However, I could not find ecpg
(by searching directories and using whereis). I also cannot find doc on
how to invoke ecpg.
The postgresql seems OK. I can initdb, postmast
help me pls.
i got an error like this when i do an insert to a table, my table dont
have bpchar type of field.
ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast
it seems 1 field in my table has bpchar t
This should work:
SELECT day, rain FROM meteo WHERE rain = (SELECT max(rain) FROM meteo
WHERE date_part('year', day) = '2001')
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Thu, 8 Mar 2001, Salvador [iso-8859-1] Mainé wrote:
> Hello:
>
> I have a tab
What is the schema of the table in question, does it have any references
to other tables and what is an example insert statement?
On Wed, 7 Mar 2001, chard wrote:
>
> help me pls.
> i got an error like this when i do an insert to a table, my table dont
> have bpchar type of field.
>
> ERROR:
Salvador =?iso-8859-1?Q?Main=E9?= <[EMAIL PROTECTED]> writes:
> I want to select the the day of maximum value for each year for a given
> measurement station.
This is exactly the sort of thing that SELECT DISTINCT ON is meant for.
See the "weatherReports" example in the SELECT man page,
http://ww
chard <[EMAIL PROTECTED]> writes:
> i got an error like this when i do an insert to a table, my table dont
> have bpchar type of field.
> ERROR: Unable to identify an operator '=' for types 'bpchar' and 'varchar'
> You will have to retype this query using an explicit cast
> it seems 1 fie
Folks,
I'm trying to delcare an array (of type Numeric) within a PL/pgSQL
function. No matter what syntax I try, however, I get a compile error.
I've tried:
DECLARE
level_array NUMERIC(8,2)[];
level_array NUMERIC[](8,2);
level_array NUMERIC[];
level_array[] NUMERIC(8,2);
and even:
lev
I'm pretty new to SQL and can't figure out how to write what should be a
simple query of two tables. Could someone here possibly help me out?
Table 1 has two fields I'm interested in: TITLE_NO and EFFECT_DATE
Table 2 also has two fields of interest:TITLE_NO and PAIDTO_DATE
TITLE_NO is uniqu
Well, you should probably get yourself a good SQL book :) but here's a try
(untested). How about something like:
SELECT DISTINCT title_no, paidto_date
FROMtable1, table2
WHERE table1.title_no = table2.title_no
AND table1.effect_date <> table2.paidto_date;
Again
Hi,
I am using the following query to find the attributes of a given table, and
their datatypes:
select typname,attname
from pg_class c, pg_attribute a,pg_type t
where relname = 'table_name' and
attrelid = c.oid and
atttypid = t.oid and
attnum > 0;
Can anybody explain
Dear Friends,
I am having a few problems using a select query which joins two views
containing aggregate functions (see query 1 below). Entering this query in
MS Access through ODBC (linking the tables in) I get the correct result of:
uidtotalansweredcorrecttotaltimew
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
--
On Mon, 12 Mar 2001 20:52:02 + (UTC), [EMAIL PROTECTED] ("Josh
Berkus") wrote:
>1. Unlike PostgreSQL, MSSQL server will not permit you to override an
>"Identity Value" auto-incrementing field;
That's almost correct. You cannot *update* an identity column, but you
can override it on insert if
* Alder <[EMAIL PROTECTED]> menulis:
> I'm pretty new to SQL and can't figure out how to write what should be a
> simple query of two tables. Could someone here possibly help me out?
>
> Table 1 has two fields I'm interested in: TITLE_NO and EFFECT_DATE
> Table 2 also has two fields of interest:
Are you looking for "grant all to public" or "grant select to public"?
- Original Message -
From: "Roland Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 3:40 PM
Subject: Re: [SQL] Permissons on database
> >
pg_class holds the relation information (tables, etc)
pg_attribute holds attribute information (attname), it
keeps the oid of the relation it's on in attrelid and the
oid of the type as atttypid
pg_type holds type information (typname)
The attnum>0 is to limit the check to user attributes.
Spy <[EMAIL PROTECTED]> writes:
> Tom Lane a écrit :
>> Is that actually how MySQL interprets two parameters? We treat them
>> as count and offset respectively, which definition I thought was the
>> same as MySQL's.
> But MySQL's syntax is different, as found on
> http://www.mysql.com/doc/S/E/SE
* Cliff Crawford <[EMAIL PROTECTED]> menulis:
>
> SELECT table2.title_no, table2.paidto_date
> FROM table1, table2
> WHERE table1.title_no=table2.title_no
> AND (date_part('month', table1.effect_date) !=
> date_part('month', table2.paidto_date)
> OR date_part('day
"david morgan" <[EMAIL PROTECTED]> writes:
> I am having a few problems using a select query which joins two views
> containing aggregate functions (see query 1 below).
I don't think there's any chance of making that work in pre-7.1
Postgres. Sorry :-(.
As a workaround, consider selecting t
Hi!
I've for a while now been using the != operator in my sql queries, but in
almost all examples I see <> instead. Are there any good reason to use
any instead of the other? I prefer !=, but if you convince me, I'll change to
what you other guys are using ;-)
Regards,
Patrik Kudo
ech`echo xiun
33 matches
Mail list logo
