On Wed, 17 Aug 2016, 1:36 p.m. Venkata B Nagothi, wrote:
> On Mon, Jun 13, 2016 at 8:37 AM, Patrick B
> wrote:
>
>> Hi guys,
>>
>> In the db I'm working one, it will be three tables:
>>
>> visits, work, others.
>>
>> Everything the customer do, will be logged. All inserts/updates/deletes
>> will
On Mon, Jun 13, 2016 at 8:37 AM, Patrick B wrote:
> Hi guys,
>
> In the db I'm working one, it will be three tables:
>
> visits, work, others.
>
> Everything the customer do, will be logged. All inserts/updates/deletes
> will be logged.
>
> Option 1: Each table would have its own log table.
> vis
Also...
if something is changed inside the visits table (delete/insert/update), the
visits_logs table will be logging the change.
However, some joins between those three tables will become necessary in
some point, as visits and works tables are related somehow...
am Mon, dem 21.07.2008, um 9:40:19 +0200 mailte Torsten Zühlsdorff folgendes:
> A. Kretschmer schrieb:
>
> >>if I have a table, the_table, with a DATE field, i'll call it 'day', and
> >>I'd like to find all rows whos day falls within a given month, which of
> >>the following methods is faster/
A. Kretschmer schrieb:
if I have a table, the_table, with a DATE field, i'll call it 'day', and
I'd like to find all rows whos day falls within a given month, which of the
following methods is faster/costs less:
1.
SELECT * FROM the_table WHERE day LIKE '2008-01-%';
2.
On Sunday 20 July 2008, Robert Urban <[EMAIL PROTECTED]> wrote:
> Hi PostgreSQLer,
>
> if I have a table, the_table, with a DATE field, i'll call it 'day', and
> I'd like to find all rows whos day falls within a given month, which of
> the following methods is faster/costs less:
>
> 1.
>
> SE
am Sun, dem 20.07.2008, um 20:08:21 +0200 mailte Robert Urban folgendes:
> Hi PostgreSQLer,
>
> if I have a table, the_table, with a DATE field, i'll call it 'day', and
> I'd like to find all rows whos day falls within a given month, which of the
> following methods is faster/costs less:
>
> 1
I am so sorry. I sent a mail draft.On 6/20/06, Lee Riquelmei <[EMAIL PROTECTED]> wrote:
hi,all. A strange question is as follows:I have two PCs:machine A: FreeBSD
5.4 with PostgreSQL 8.1.2machine B: Windows XP with PostgreSQL 8.1.2A and B are with same hardware configuration and in a 100Mbit LAN.
