Try pgAdmin - Google will find it for you.
~p
On Wed, 2007-04-25 at 10:10 +0530, saji varghese wrote:
>
> Hi,
> Can i get GUI tool for PostgreSQLin LINUX.Pls let me know from wher i
> candownload the same.
>
***Confidentiality and Privilege Notice***
The ma
Hi,
Can i get GUI tool for PostgreSQLin LINUX.Pls let me know from wher i
candownload the same.
Regards
SAJI VERGHESE
+919941140433
- Original Message
From: "Wilkinson, Jim" <[EMAIL PROTECTED]>
To: Penchalaiah P. <[EMAIL PROTECTED]>; pgsql-sql@postgresql.org
Sent: Tuesday, 24 April,
I have a database with the following tables:
zip {
zip_id bigserial,
zip_cd varchar(6) -- this is indexed
}
city {
city_id bigserial,
city_name varchar(50)
}
zip_city {
city_id bigint (FK to city table),
zip_id bigint (FK to zip table),
longitude numeric,
latitude numeri
I am attempting to create a moving average elements function that will
return a set of elements in a particular moving average and am having
difficulty iterating thrrough the passed in array properly. Any help
would be greatly appreciated.
code below...
select getmovavgelements( aggarray(trade_d
On Tue, 24 Apr 2007, Penchalaiah P. wrote:
> Hi
>
> I have the data like this in temp table
>
> SQL> Select sno, value from temp;
>
> SNO Value
>
> 1 650.00
>
> 2 850.00
>
> 3 640.00
>
> 3 985
Don't forget to cc: the list
Wilkinson, Jim wrote:
Hi Richard, your example worked find , but when I substitue my view into
the function and the tale name, I get the following error:
ERROR: wrong record type supplied in RETURN NEXT
CONTEXT: Pl/pqSQL function "create_view" line 11 at return next
On þri, 2007-04-24 at 17:39 +0530, Penchalaiah P. wrote:
> Hi
>
> I have the data like this in temp table
>
> SQL> Select sno, value from temp;
you seem to be assuming a specific order for this.
gnari
---(end of broadcast)---
TIP 9: In versio
Hi Dmitry,
On Tue, 2007-04-24 at 15:31 +0300, Dmitry Turin wrote:
> J> How do I see employees in just one department?
>
> department[id="1"].employee >>;
>
> or
>
> department[name="Technical"].employee >>;
How is that any different or better than a standard SQL SELECT (or to
use another conte
Hi,
try this. It's working...
SELECT t1.sno, sum(t2.value)
FROM temp as t1, temp as t2
WHERE t1.sno >= t2.sno
GROUP BY t1.sno;
but not completely. The problem is the this suppose your sno is uniqu. But as I
see 3 is not.
Anyway it may help you.
>I have the data like this in temp table
>
>SQL>
Select sno AS "SNO",
SELECT value AS "VALUE",
get_sum(value) as SUM
from temp;
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.
Sent: April 24, 2007 8:09 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] hi
Hi
I have
Dmitry Turin wrote:
Good day, Joe.
I would change your examples to use less abstract
data, like department/employee, customer/product/order/order_line
J> I contend that then you'd find more people
J> receptive to your ideas or at least able to criticize them from more
J> concrete viewpoints.
Hi
I have the data like this in temp table
SQL> Select sno, value from temp;
SNO Value
1 650.00
2 850.00
3 640.00
3 985.00
5 987.00
9 9864.00
BD> Please stop using my personal email adsress in CC or BCC.
BD> Forum related mails should only be send to the forum!
I promise
BD> Several revisions:
BD> 1. "Adabas" is this
BD> http://www.softwareag.com/Corporate/products/adabas/download/default.asp
BD> (ada51.zip, 31Mb)?
BD> 2. "GT.M" exists
Good day, Joe.
J> "Fictional" is IMO not a good choice for
J> describing aggregates, because it means "a story that is not true",
J> whereas an SQL aggregate is something that is "true" (in the
J> mathematical sense) but is "derived" from other values.
It means, that TML and DDL aggregates have d
Hello,
I'd like to ask you for a help. I'm in trouble with $subj. I need something
like documentation of PostgreSQL in chapter 8.11.5 says.
Inside trigger I have record type NEW which is composite type. How could one
do something like :
text_var:=to_char(NEW)
So if NEW.at1='test'
Good day, Joe.
>> >I would change your examples to use less abstract
>> > data, like department/employee, customer/product/order/order_line
J> I contend that then you'd find more people
J> receptive to your ideas or at least able to criticize them from more
J> concrete viewpoints.
I expected, th
Good day, Bart.
> I'll continue with the analogy
Let's suppose, that you want to compare rational and hierarchical
DBMS instead of discussion about removing gaskets
(by the way, hierarchical DBMS also need gasket between itself and
external world).
Because TML should integrated inside rational DB
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
18 matches
Mail list logo
