Hello everyone, Good day! Could anyone help me translate this query in Microsoft
Access to Postgresql. I'm having a difficulty. Pls...
Query1:
SELECT items.description, Sum(supplieditems.qty) AS SumOfqty
FROM items INNER JOIN supplieditems ON items.itemno = supplieditems.itemno
GROUP BY items.de
Hello everyone, Good day! Could anyone help me translate this query in Microsoft Access to Postgresql. I'm having a difficulty. Pls...
Query1:SELECT items.description, Sum(supplieditems.qty) AS SumOfqtyFROM items INNER JOIN supplieditems ON items.itemno = supplieditems.itemnoGROUP BY items.descript
Check contrib/tsearch2 and http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2
for documentation
Oleg
On Fri, 7 Nov 2003, Martin Kuria wrote:
> Hi,
> I have a content management system, for my database driven website developed
> using php and postgresql but I don't know how to develop
Download the latest version of PostgreSQL and look in the contrib/tsearch or
contrib/tsearch2
directories. For documentation, see:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
http://sourceforge.net/mailarchive/forum.php?forum_id=7671
George Essig
___
can anybody recomend web hosting that provides postgresql? I have
found a couple, but their pricing is several times the going rate using mySql.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
First, I know nothing about PLC's, but I was wondering is there a way
to extract data from a SQL database file, feed that to a PLC is some
manner, and then have the PLC trigger a diverter gate based on the
value in the table exceeding a certain value, to divert parts to
another location.
Am I off
I have a problem in using the to_char function in a SQL-Statement
and addressing it with DB_FETCHMODE_OBJECT under PEAR DB.
The follwing code is working fine unless I'm adding the to_char function:
--
require_once 'DB.php';
$dsn = $$$;
$
On Tue, 04 Nov 2003, Tom Lane wrote:
> Jamie Lawrence <[EMAIL PROTECTED]> writes:
> > I don't understand why moddate isn't getting set to now() in the above.
>
> Josh fingered the problem there --- you need a BEFORE trigger if you
> want to affect the data that will be stored. I had missed that
How remove a password validity ?
CREATE USSER x WITH VALID UNTIL 'uu'
ALTER USSER x WITH VALID UNTIL 'uu'
but how remove password valid until ?
Thank
Alban
---(end of broadcast)---
TIP 7: don't forget to increase your free spa
Am 01.11.2003 12:00 meinte Marcus Krause:
> $query .= "SELECT news_id,to_char(news_time,'DD.MM. HH24:MI'), ";
The real code is without the comma at the end of the line above, so
it's not a simple SQL-Statement problem!
---(end of broadcast)---
i have execute
ALTER USER postgres WITH NOCREATEUSER;
it's work very well but now, i cant add, drop, alter user, alter group...
ALTER USER postgres WITH CREATEUSER;
--> ERROR : ALTER USER : permission denied
there is a solution ?
Thank
ALban
---(end of broadcast)---
Hi,
I need to query each column's constraint and name of a table in
postgreSQL v7.3.4 with a single SQL query but don't know how. Would
appreciate any pointers!
Thank you.
Regards,
Damon
---(end of broadcast)---
TIP 8: explain analyze is your frie
alban wrote:
> How remove a password validity ?
>
>
> CREATE USSER x WITH VALID UNTIL 'uu'
> ALTER USSER x WITH VALID UNTIL 'uu'
> but how remove password valid until ?
I think you have to specify the data as 'infinity'.
test=> CREATE USER x WITH VALID UNTIL '2005-01
alban wrote:
> i have execute
> ALTER USER postgres WITH NOCREATEUSER;
> it's work very well but now, i cant add, drop, alter user, alter group...
>
> ALTER USER postgres WITH CREATEUSER;
> --> ERROR : ALTER USER : permission denied
>
> there is a solution ?
Uh, you removed createuser permission
Bruce Momjian <[EMAIL PROTECTED]> writes:
> alban wrote:
>> i have execute
>> ALTER USER postgres WITH NOCREATEUSER;
> Uh, you removed createuser permission from the postgres super-user.
That was a really bad move :-(
If you have no superusers left, I think your only option is to shut down
the p
http://www.hub.org
http://www.pghoster.com
http://www.commandprompt.com
On Thu, 6 Nov 2003, chester c young wrote:
> can anybody recomend web hosting that provides postgresql? I have
> found a couple, but their pricing is several times the going rate using mySql.
>
> ___
http://www.iniquinet.com
When grilled further on (Thu, 6 Nov 2003 16:39:14 -0800 (PST)),
chester c young <[EMAIL PROTECTED]> confessed:
> can anybody recomend web hosting that provides postgresql? I have
> found a couple, but their pricing is several times the going rate using mySql.
>
--
1
Rich,
> I don't want to abuse you - so if this is the wrong forum for this, feel
> free to toss it back with direction :-)
No, but I do think that you should CC a mailing list becuase:
1) Someone else may have direct experience with your problem and answer more
quickly than me, and:
2) Other peo
Rich,
> That was my thought - I was fairly sure I fixed it though. Do, really
> need to be specific in terms of type in terms of int, or can I put numeric,
INT and numeric are fairly different, and I believe that SRF return types are
very fussy about data types; I wouldn't be surprised if y
Postgresql 7.4.rc1 on i686 pc linux compiled by gcc 2.06.
All configuration settings are default.
Hi,
Trying to find a way to improve range query performance.
The table Test has about 30 million records.
-- DLong, Dtimestamp, Dint, etc are domains of the respective types.
create table Test (
i
Try CLUSTER --- that usually helps with index scans on ranges.
---
ow wrote:
> Postgresql 7.4.rc1 on i686 pc linux compiled by gcc 2.06.
> All configuration settings are default.
>
>
> Hi,
>
> Trying to find a way to impr
On Sat, 8 Nov 2003, ow wrote:
> Postgresql 7.4.rc1 on i686 pc linux compiled by gcc 2.06.
> All configuration settings are default.
>
>
> Hi,
>
> Trying to find a way to improve range query performance.
>
> The table Test has about 30 million records.
>
> -- DLong, Dtimestamp, Dint, etc are domain
22 matches
Mail list logo
