When i am executing this query, i am facing the
select
s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as
svcdescr from vwsubsmin s
inner join packages p on s.svcno=p.pkgno
inner join account a on a.actno=s.actno
inner join ssgdom d on a.domno=d.domno
in
estamps
To: "Srikanth"
Cc: pgsql-sql@postgresql.org
Date: Tuesday, 17 March, 2009, 8:36 PM
Srikanth wrote:
> Dear all,
>
> I have a table that records User Login Sessions with two timestamp fields..
> Basically Start of Session and End of a Session (start_ts and end_ts). Eac
Dear all,
I have a table that records User Login Sessions with two timestamp fields.
Basically Start of Session and End of a Session (start_ts and end_ts). Each row
in the table identifies a session which a customer has used.
Data from the table (session):
-
custo
Hi, I am using postgre sql server on linux server but for my database I am
using storedprocedures which i need to create , but there are no commands to
create procedures it says it does not support is there any way to work with
stored procedures in postgre sql server.
thanks,
srikanth
I have a linked list representing a tree. How do I
store it in the database? Does PGSQL give us any
special procedures to deal with such structures?
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://pers
I have a query that calculates the average of
difference between timestamps. I want the output to be
upto 1 decimal point. How do I do it?
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
I have a query as follows:
SELECT date(c.timestart) as ondate,
c.userid,
u.username,
count(c.callinfoid) as numCalls,
sum(b.broquant) as numBroc,
sum(b.broquant)/count(c.callinfoid) as
BrochuresaCall
marketingbyoffice is a view.
I start the postmaster, then issue the following query
in psql console. It goes to sleep forever:-)
Why?
The log is as follows:
--log -
010404.13:49:14.612 [1352] StartTransactionCommand
010404.13:49:14.612 [1352] query: SELECT * INTO TEMP
TABLE marketi
Hi,
I have a table like this:
location| numbrochures | marketing
---+--+---
101 Asheville, NC |4 | NEWS
101 Asheville, NC |1 | TV
101 Asheville, NC |3 | RADIO
101 Asheville, NC |
