Hello, all,
I would like to take a timeseries of data and extract the rows of data
flanking the gaps in it. So I need to compare timestamps from two adjacent
rows, and determine if the interval is greater than the standard sampling
interval.
Thanks for any help.
Regards,
H. Jenkins
---
Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?
---(end of broadcast)-
Hello,
I have a table of rows which partially duplicate one another and need to
be merged and moved into a table with a primary key.
As an additional complication, some of the duplicates contain different
information, ex.:
schema1.datatable: key1 None None 34
schema2.datatable: key1 12
Hello, all,
On the subject of the COPY command
(http://www.postgresql.org/docs/current/interactive/sql-copy.html), is it
the case that the HEADER, QUOTE, escape, FORCE QUOTE, and FORCE NOT NULL
options can only be used in CSV mode? If so, why? A tab-delimited table
with a header line and quoted st
