Screenshot instructions:
Windows
Mac
Red Hat Linux
Ubuntu
Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)
You can subscribe to this list here.
2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(9) |
Nov
(18) |
Dec
(5) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2002 |
Jan
(11) |
Feb
(7) |
Mar
(7) |
Apr
(7) |
May
(17) |
Jun
(33) |
Jul
(19) |
Aug
(3) |
Sep
(19) |
Oct
(18) |
Nov
(27) |
Dec
(13) |
2003 |
Jan
(12) |
Feb
(8) |
Mar
(11) |
Apr
(42) |
May
(19) |
Jun
(49) |
Jul
(23) |
Aug
(12) |
Sep
(2) |
Oct
(8) |
Nov
(8) |
Dec
(13) |
2004 |
Jan
(13) |
Feb
(2) |
Mar
(7) |
Apr
(7) |
May
(6) |
Jun
(13) |
Jul
(4) |
Aug
(12) |
Sep
(6) |
Oct
(6) |
Nov
(50) |
Dec
(10) |
2005 |
Jan
(20) |
Feb
(20) |
Mar
(2) |
Apr
(10) |
May
(12) |
Jun
(7) |
Jul
|
Aug
(4) |
Sep
(3) |
Oct
|
Nov
|
Dec
|
2006 |
Jan
(2) |
Feb
(2) |
Mar
(5) |
Apr
(6) |
May
(3) |
Jun
(17) |
Jul
(2) |
Aug
(8) |
Sep
(1) |
Oct
(5) |
Nov
(3) |
Dec
(2) |
2007 |
Jan
(2) |
Feb
|
Mar
|
Apr
(2) |
May
(1) |
Jun
(3) |
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
2008 |
Jan
|
Feb
(1) |
Mar
(1) |
Apr
|
May
(3) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
(1) |
Dec
|
2009 |
Jan
(2) |
Feb
(1) |
Mar
(3) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(3) |
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
2011 |
Jan
(2) |
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
(1) |
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
(1) |
31
(2) |
|
|
|
From: larry price <laprice@gm...> - 2005-08-31 22:52:48
|
I'm using a dictionary interpolated string to create a query statement. When I generate the query by hand sql =3D query % params and execute the sql from inside psql, it works. when i create cursor and use cursor.execute(query,params) i get the following traceback Traceback (most recent call last): File "<stdin>", line 1, in ? File "/tmp/python-5481BIu.py", line 134, in insert_title File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3048, in execute self.res =3D self.conn.conn.query(_qstr % parms) TypeError: float argument required line 3048 seems to be where the Exception is handled, but the 'self.res =3D ...' line occurs in method callproc, and I don't see where it gets called from inside the method execute. the only oddball column is one that is of type numeric(9,2) do I need to wrap this in PgNumeric before I hand the dictionary to execute Or is there something deepr going on? --=20 http://Zoneverte.org -- information explained Do you know what your IT infrastructure does? |
From: Billy G. Allie <bill.allie@de...> - 2005-08-31 03:24:42
|
On Tue, 2005-08-30 at 16:44 +0000, Rod MacNeil wrote: > Hi All, > > I'm using pyPgSQL 2.4 postgres 7.4.7 on fedora core 3. > > I have a question about the data type returned in cursor.description when oid is included in the select. > > When I run a query like "select oid, field1,field2 from mytable where field2='x'". > > cursor.description says the oid column is type 'rowid' if there are result rows, but if there are no result rows it says the type is 'blob'. > > Is this a bug? > > Rod MacNeil Not really. It's caused by the fact that an OID can represent a rowid or a postgresql large object (i.e. blob). The only way to tell which one it is is to see if the value of the OID exists as a large object or not. Since there is no result (and hence not value) the lookup can't be made so a type of blob is assumed. -- ____ | Billy G. Allie | Domain....: Bill.Allie@... | /| | 7436 Hartwell | MSN.......: B_G_Allie@... |-/-|----- | Dearborn, MI 48126| |/ |LLIE | (313) 582-1540 | |
From: Rod MacNeil <rmacneil@in...> - 2005-08-30 16:45:06
|
Hi All, I'm using pyPgSQL 2.4 postgres 7.4.7 on fedora core 3. I have a question about the data type returned in cursor.description = when oid is included in the select. When I run a query like "select oid, field1,field2 from mytable where = field2=3D'x'". cursor.description says the oid column is type 'rowid' if there are = result rows, but if there are no result rows it says the type is 'blob'. Is this a bug? Rod MacNeil =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D NOTE: This e-mail message is intended only for the named recipient(s) above and may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this e-mail message. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D |
From: <gherzig@fm...> - 2005-08-17 14:30:20
|
Hi all. I want to send some dictionary as an argument for my plpythonu function. Let's say CREATE OR DECLARE FUNCTION test(__dictionary__) but cant figure out if it is possible or not. Is it? Thanks a lot. --=20 Gerardo Herzig Direccion General de Organizacion y Sistemas Facultad de Medicina U.B.A. |