OM gnis_international_view,
> gnis_usa_view;
> ERROR: column "the_geom" duplicated
> ERROR: column "the_geom" duplicated
>
> Any ideas on how I can achieve what I am seeking
Yes but you will have to specify each column name from each table and create
alias
s that describe how to set parameter variables before executing
a query that uses
them.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
ql.org/docs/8.1/interactive/user-manag.html
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ross
transactions or even user
sessions. I was curious of the datatype for pin, in the previous example I
think that it was
defined as a varchar. Perhaps casting the sequence to a varchar would be the
finial step before
updating/inserting the records.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Thanks for I think the list that you are looking for is:
[EMAIL PROTECTED]
--- Mark <[EMAIL PROTECTED]> wrote:
>
> Hi ,
>
>
> Location: San Diego, CA [You can also TeleCommute...]
>
> Duration: 6+ months.
>
>
>
> This is Mark with ProV International, This email is in regards to
nv_id = i.id and
> --mdef2.id = im2.milestone_id and
> im1.datereceived IS NULL
Is there a reason that these two lines are commented out in the postgresql
query?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
an a
like. Have you looked at the contrib module tsearch2?
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subs
> Thanks, It works! I have tried:
>
> insert into employee (c, nome, sal) values(1, 'emp name', '(1, (01/01/2000,
> 01/01/2000))' );
>
> And it doesn't work!
What is the error message?
Regards,
Richard Broersma Jr.
-
ve do it ?
Why not use a conventional table to hold this information that references your
employee table?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> I'm having trouble getting the Windows ODBC drivers to work. They used
> to work, but it's been 6 months or so.
If you don't find the answer you are looking for on this list, maybe try:
[EMAIL PROTECTED]
Regards,
Richard Broersma Jr.
---
and then make up some results
that you would
really like to get. I am not entirely clear what you are trying to achieve.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
eractive/sql-selectinto.html
and particularly this example:
http://www.postgresql.org/docs/8.2/interactive/sql-selectinto.html#AEN54014
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
yet when it comes PL/pgsql. Thanks for the
clarification.
Regards,
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
can refer to any of it's enternal tables any
more. So (t1.c=...)
should really be (t.c=...).
this is what I expect would work:
select
*
from
t1
left outer join
t2
on
((t1.a,t1.b) = (t2.a,t2.b))
left outer join
t3
on
(t1.c = t3.c)
;
Regards,
ger record because he/she wishes to get
off early you will
need to have an additional update statement to shift down higher valued records
insure that the
range does not have any gaps.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
not believe that the "IF" predicate exists. However the
"CASE" predicate does
and will do what you want.
http://www.postgresql.org/files/documentation/books/aw_pgsql/node44.html
Regards,
Richard Broersma Jr.
---(end of broadcast)--
> Thanks FOR your prompt responseBut USING CASE issue still NOT resolved
> Oracle prompts same error.
I see, was answers to you get from the oracle mailing lists regarding this
problem? ;o)
Regards,
Richard Broersma Jr.
---(end of bro
anything else with it.
select
*
from
(
select doc_num from documents limit 10
) as D1
left outer join
comments
on
(D1.doc_num = comments.doc_num)
;
Regards,
Richard Broersma Jr.
---(end of broadcast)
> hi, could you tell me, what have I do for not reveice more emails
Send an email to:
[EMAIL PROTECTED]
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating
> row3 and so on...
just an idea.
select (A.atime - max(B.atime)) duration
from table A join table B
on (A.atime > B.atime)
group by A.atime;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our
> CIDATIME STATE
> 10112/10/2006 1
> 10112/12/2006 2
> 10112/14/2006 1
> 10112/17/2006 2
> 10212/14/2006 1
> 10212/16/2006 2
> 10212/18/2006 3
select A.cid, (A.atime - max(B.atime)) duration, A.sta
gt; 102 |2 | 1
> 102 |2 | 2
> 102 |2 | 3
> (7 rows)
Good catch! I should have read the requirements a little more closely, but at
4:30 am when I just
woke up, slight details are very hard for me to focus on. :o)
Regards,
Richard Broersma Jr.
ng line:
List-Unsubscribe: [EMAIL PROTECTED]
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
UUM FULL & possible REINDEX.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
scribes its use:
http://www.postgresql.org/docs/8.2/interactive/app-reindexdb.html
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
g modeled. :-)
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
--- Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
> Thank you but I must inc an specific row. How to do that ?
>
Does,
UPDATE your_table
SET your_row = your_row +1
WHERE your_pkey = ;
not do what you need?
Regards,
Richard Broersma Jr.
---(end
ing views made update-able with the
Postgresql rule system.
Here is a link were I present how it is done.
http://archives.postgresql.org/pgsql-general/2006-12/msg00913.php
Let me know if you have any questions.
Regards,
Richard Broersma Jr.
---(en
ere is a better way of doing it. ;)
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
another table. Before this, I
think table
inheritance could only be created from the CREATE TABLE statement.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nom
using PostgreSQL >= 8.0 you can use dollars sign quoting like the
following:
INSERT INTO TABLE2 (TE_INDI) VALUES ($SANT'ANGELO LODIGIANO$);
or even a custom quotation identifier:
INSERT INTO TABLE2 (TE_INDI) VALUES ($myquote$SANT'ANGELO LODIGIANO$myquote$);
Would
> INSERT INTO TABLE2 (TE_INDI) VALUES ($SANT'ANGELO LODIGIANO$);
My mistake, a single $ will not work you need two like $$:
INSERT INTO TABLE2 (TE_INDI) VALUES ($$SANT'ANGELO LODIGIANO$$);
Regards,
Richard Broersma Jr.
---(end
Add
FROM Table1 B
WHERE myFKey_id = B.Table1Id;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
es we can find 'Elmo', 'Street'.
>
select zipcode
from zipzodetable
where address ~ 'Elmo'
and address ~ 'Street';
If the query is too slow I expect that installing the tsearch2 contrib module
and using the
tsearch2 type queries would give you want
> Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%')
>
> But I still need to Separete all strings.
What is it that you are trying to achieve? What string would you like to
seperate?
Regards,
Richard Broersma Jr.
-
--- Gerardo Herzig <[EMAIL PROTECTED]> wrote:
> Hi dudes, i have the following question
> i have 2 tables with the same format, and i want to know if is there a
> possibility of using some sort of count(*) for achieving this result:
> select a from table1 where (condition) union select a from ta
for more extended queries? Any other design ideas?
Perhaps tsearch2 would work for you. I am just starting to learn about it.
Maybe you can create
a tsearch2 GIN index on each table in the view, and then use tsearch2 queries
to quickly retrieve
your results.
Regards,
R
sequential numbers, or is just something that
> feels good / looks good?
The following link develops the use of a gapless sequence:
http://www.varlena.com/GeneralBits/130.php
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE
One other point to be aware of, Postgresql does not allow your to reference
other databases in the
DB-cluster directly. It is possible but you need to add a contrib module
called dblink:
http://pgfoundry.org/projects/snapshot/
Hope this helps,
Rega
> But I DELETE all conflicting those rows prior to the slow DELETE, just
> so the FK check is never hit. Should I be looking at subverting the FK
> check mechanism somehow? The necessary index would be huge, and
> relevant only on this particular operation which happens every few
> months, if tha
/interactive/datatype-numeric.html#DATATYPE-FLOAT
I didn't see anything about numeric being a string type,
http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL
Regards,
Richard Broersma Jr.
---(end of broadcast)--
s,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Is Mr. Celko mistaken? Does anyone know if PostgreSQL has any functions that
> I can turn these
> VALUES rows into columns so that the CROSS JOINS will work?
Having posted, I just realized what the correct syntax is:
--- Collin Peters <[EMAIL PROTECTED]> wrote:
> I am having the same problem that is documented elsewhere in the
> archives. Namely when you have a INSERT RULE on a VIEW the nextval()
> function doesn't behave properly (or it doesn't behave how I'd like it
> to).
>
> http://archives.postgresql.o
27;pid',
'isometric', 'airsupplydetail',
'mountingdetail',
'pnuematicdetail'))) ;
CREATE TABLE docs.schematic
(
did integer primary key references
docs.drawing(did) on delete cascade,
doccode varchar(30) not null,
cid integer references equ.lcp(cid),
constraint
schematic_doccode_chk
check ( doccode = 'schematic')) ;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
code:
//This will always work:
For i = 1 to 1000 do
INSERT INTO Vschematic VALUES ( .. some unique values .. );
Next i
//These will always fail:
INSERT INTO Vschematic SELECT * FROM A_TABLE LIMIT 1000;
or
INSERT INTO Vschematic VALUES ( unique vals 1),(unique vals 2), ..., (unique
vals n);
Reg
Temporal Referential-Integrity
(RFI) if my
questions are unclear.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
e CREATE
ASSERTION method will
only prevent you from from altering the data in a way so as to make it
inconsistent between the
two tables.
> [2](http://www.amazon.com/gp/product/1558608559/)
I did purchase the Chris Date book, but I haven't spend any time reading it
since its
illus
functions-comparisons.html#ROW-WISE-COMPARISON
you can write something like:
SELECT *
FROM Your_table
WHERE (c1,c2,c3,c4) = ('a',2,'xyz',123);
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading t
does.
you have to specify every column that you want to compare, so:
row(t.col1, t.col2, t.col3, t.col4) <> row(p.col1, p.col2, p.col3, p.col4)
where the datatypes of each respective column match. i.e. t.col1 maps to
p.col1, ...
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
efault value of zero for this column.
ALTER TABLE Slparts
ALTER COLUMN onorder SET NOT NULL,
ALTER COLUMN onorder SET DEFAULT 0;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
se the where syntax in your query since it does not and
cannot reference a NEW
or OLD tuple.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
t; > - with locking, lookup for last id of typ
> > - with locking, keep another table of typ and nextval
here is supplementary information of gap-less sequences:
http://www.varlena.com/GeneralBits/130.php
Regards,
Richard Broersma Jr.
---(end of broadcast)
known i.e. null.
SELECT * FROM users WHERE happy IS NULL;
UPDATE users SET happy = false WHERE happy IS NULL;
ALTER TABLE USER ALTER COLUMN happy SET NOT NULL;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I am not sure about the proper syntax for plpgsql. However, IS
NULL is correct
for sql statements.
Also, don't forget to cc. the list so that other can chime in as well.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2:
FROM your_view
ORDER BY duration desc;
or
SELECT V1.id, V1.phone_number, V1.duration
FROM your_view AS V1
INNER JOIN ( SELECT phone_number, max( duration )
FROM your_view
GROUP BY phone_number ) AS V2( phone_number, duration )
ON (V1.p
ot like
an existing
replication solution, "Slony". It will do exactly what you want, and is
already stable for
production systems.
http://pgfoundry.org/projects/slony1/
Regards,
Richard Broersma Jr.
---(end of broadcast)---
e_c_foreign_key ON c ( a, b );
SELECT a.x, b.x
FROM ( SELECT DISTINCT( a_id ) a_id, b_id
FROM c ) AS c( a_id, b_id )
INNER JOIN a
ON c.a_id = a.id
INNER JOIN b
ON c.b_id = b.id;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
oops...
I meant "DISTINCT ON ( a_id )"
--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> SELECT a.x, b.x
> FROM ( SELECT DISTINCT ON ( a_id ) a_id, b_id
^^
>FROM c ) AS c( a_id, b_id )
> INNER JOIN a
>
alias [, ...] |
column_definition
[, ...] ) ]"
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
--- Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Any function declared as returning SETOF RECORD needs it, when you don't
> use OUT params. Before OUT params existed, it was the only way to use
> those functions.
Thanks everyone for the exposition! It makes sense.
Regards,
E featured = true;
This will ensure that the sum( featured = true ) <= sum( unique( catagories )).
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-noma
OOPS!
--- Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> CREATE UNIQUE INDEX Only_one_row_true
> ON Your_table ( featured )
>WHERE featured = true;
>
> Or if you want to only allow 1 featured article per catagory then:
>
> CREATE UNIQUE INDEX Onl
le1.id
> UNION ALL
> SELECT table1.id,
>table1.col1,
>CAST( NULL AS CHARACTER( 3 )),
>table3.type2
> FROM table1
> JOIN table3 ON table3.fk_table1 = table1.id;
Would the above changes work?
Regards,
Richard Broersma Jr.
---(e
ostgresql.org/docs/8.2/interactive/sql-createview.html
I've created large SQL scripts that employ:
DROP VIEW IF EXITS viewname;
CREATE VIEW ...
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
u open psql -U your_db_user -d your_database_name.
and type:
\d schema_name.view_name
was does it show as the definition of the column.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by
1
> 3 3
>
>
> Now what I want to have is the items that match with id_search 1 and
> 2 and 3. Therefore I use the following SQL query.
SELECT id_search
FROM Search_item
GROUP BY id_search
HAVING Count( * ) = 3
API on top of it that manages the data. Not a big deal but it
> complicates things :-)
The veil project already does this.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
one
without?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
YMENT AGENCY PUZZLE
http://www.elsevier.com/wps/find/bookdescription.cws_home/710075/description#description
the only difference was that he was modeling employees and skillsets. IIRC,
the terminology for
the improved model was the "full disjuctive" model.
Regards,
Richard Broersma Jr.
-
to : [EMAIL PROTECTED] .
This mailing list ( pgsql-sql@postgresql.org ) is really intended for
discussions of how to construct SQL queries to achieve desired results in a
PostgreSQL database.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2:
you are probably after:
UPDATE Inventory
SET number = 0
FROM Things
WHERE Inventory.thing_fk = Things.thing_id
AND Things.color = 'red';
IIRC, Joe Celko referrers to this syntax as "T-SQL".
Regards,
Richard Broersma Jr.
---(end of broadcast)-
ts( part_nbr, part_type)
ON DELETE CASCADE
ON UPDATE CASCADE);
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--- On Mon, 12/10/07, Scott <[EMAIL PROTECTED]> wrote:
> I am having trouble with an insert rule that also does an
> update. It works
> fine for a single insert but multiple inserts in a single
> statement don't
> behave as I expected.
Yup, that is the limitation of rules. They are only useful
construct my own
sql queries that provide the same useful information as 'psql \d'. So instead,
I cheat:
start psql with the '-E' option to echo all sql strings psql sends to the
back-end server.
Simply copy and tailor each statement to suit your needs.
Regards,
Richard
ze these myriad of functions into one?
Below is a sample of a typical logging trigger function.
Regards,
Richard Broersma Jr.
CREATE OR REPLACE FUNCTION "project"."log_managers_ops"()
RETURNS trigger AS
$BODY$
BEGIN
IF TG_OP IN ( 'UPDATE', 'DELETE&#x
;s state that existed in "times passed".
If I didn't need to regularly provide this functionality, I would certainly use
an EAV history table.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/read
not, but you can find alot of PostgreSQL people on IRC:
http://www.postgresql.org/community/irc
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
postgresql references."
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
guage.html
You should probably use PLpgSQL since it is available across OS all platforms
and is easy to learn and use.
http://www.postgresql.org/docs/8.2/interactive/plpgsql.html
There are some nice examples in this documentation.
Your PGadmin will also have features to help the cre
from the SQL prompt?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
etermine the Primary Key
components of the table that will also be needed in the SQL string that will be
executed?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
SELECT DISTINCT ON ( B.book_id, B.title ) B.book_id, B.title, A.Author
FROM Books AS B
INNER JOIN Authors AS A
ON A.book_id = B.book_id;
--- On Mon, 12/31/07, Josh <[EMAIL PROTECTED]> wrote:
> From: Josh <[EMAIL PROTECTED]>
> Subject: [SQL] Limit # of recs on inner join?
> To:
--- On Mon, 1/7/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> select max(col1) from table
> union all
> select max(col2) from table
> union all
> select max(col3) from table
Would the following work also?
SELECT MAX( GREATEST( col1, col2, col3 ) )
FROM TABLE;
Regards
me < I2.name
WHERE --any where criteria you might have
GROUP BY I1.name, ...
HAVING COUNT(*) < 3
ORDER BY I1.name;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by dona
i'm reading the postgres documentation and i'm specifically
interested in creating stored procedures so that i can keep
as much of the business logic in the database as possible.
while reading 13.1.3 (SQL Functions on Composite Types) in
the Programmer's Guide i come across the phrase...
"When
you can't.
rjsjr
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Joseph Syjuco
> Sent: Tuesday, August 14, 2001 10:34 PM
> To: [EMAIL PROTECTED]
> Subject: [SQL] user defined function question
>
>
> how do i return a resultset from a user defined
i'm fairly new at this whole database design thing and my grasp of set
theory is not what it was when i was in college lo these many years
past. but i want to get a better idea of how to optimize sql
statements.
i have several friends that are DBA's by profession and work on oracle
and/or ms sql
My office is working on a fantasy football database and, unfortunately, I
have been tagged as the DBA. I'm a bit weak on set theory but I'm trying.
Right now I am trying to calculate up game scores into the database rather
than running through code to do that. A baseline of my schema is that:
+ E
Hello people.
I'm installing Postgresql under linux for better
performance and i want to know how is the best configuration.
My server is a dual pentium3 1ghz/1gb ram/36gb
scsi. running only postgresql. My question is:
1. What is the best linux distribuition for better
performance?
2. Doe
Hello.
I have this problem: i'm running the
postgre 7.3 on a windows 2000 server with P3 1GHZ DUAL/1gb
ram with good performance. For best performance i have
change the server for a XEON 2.4/1gb ram and for my
suprise the performance decrease 80%. anybody have a similar
experience? does
No response from the pgsql-admin list so I though I would try cross
posting here:
pgsql-sql@postgresql.org
pgsql-general@postgresql.org
I just know I am not the first to try and do this
Jim
*
Can anyone point me in a direction that may help me populate in real
time a table
Here is a Perl function a friend of mine wrote to help with this...
Problems I ran into were errors because of NON NUMERIC Characters in the
String...
Casting would fail
It doesn't catch all cases but it has been quite helpful to me
$x = $_[0];
$x =~ s/^[^-\d\.]*//;
$x =~ s/\,//g;
$x = $x * 1;
What's in your server?
Osmar Della Paschoa Jr
Software Engineer
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messag
but nothing seems to work. Anybody got any
ideas? Thanks in advance.
--
~ Michael D. Stemle, Jr. <><
(A)bort, (R)etry, (I)nfluence with large hammer
09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/p
branch? I
think the Manual on the main site is not very helpfull in this case!!! ;-(
Thanks in advance.
--
Valter Douglas Lisbôa Jr.
Sócio-Diretor
Trenix - IT Solutions
"Nossas Idéias, suas Soluções!"
www.trenix.com.br
[EMAIL PROTECTED]
Tel. +55 19 3402.2957
Cel. +55 19 9183.4244
--
Thank you, very much. I pass through extract(epoch from x).
On Wednesday 12 March 2008 19:58:07 Aurynn Shaw wrote:
> Valter Douglas Lisbôa Jr. wrote:
> > Hello all.
> >
> > I working with postgreSQL for a couple of months, and now I trying to
> > convert timestamp co
101 - 197 of 197 matches
Mail list logo
