Jaime Casanova wrote:
On 11/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi
Looking the e-mail I remembered a question.
I saw that "select extract (week from now()::date)" will return the
week number
of current year. But, how can I convert a week to the first reference
date. Ex:
select ex
I have two similar but not identical tables.
I would like to create a view that combines the contents of both tables
into a single view, where each record in each table is visible as a
separate record in the view.
table a
Column | Type | Modifiers
---+
On Thu, 2005-07-14 at 15:24 -0700, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am wondering if anyone can tell me how I can obtain only the list of
> data table in postgresql without function and other ancillary tables. I
> hope that I can add a tag that can filter only data table.
>
> I am using the fo
I have been having some trouble with a particular table view. An UPDATE
command is not only changing the applicable record it is also creating a
new record as well.
wholesale=# select * from accounts_supplier;
id | name | contact | addr| addr2 | town |
postcode | st
