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
"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
* 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
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.
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
> >
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
* 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:
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
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
--
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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__
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
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
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
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
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 -
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
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
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
33 matches
Mail list logo
