"Gabriel Bravo" <[EMAIL PROTECTED]> writes:
> I had a view created as:
> CREATE OR REPLACE VIEW vensamblado AS
> SELECT DISTINCT cuestionario.idcuestionario,
> cuestionario.nombrecuestionario, riesgo.idriesgo, riesgo.nombreriesgo,
> riesgo.resultado, pregunta.idpregunta, pregunta.nombrepregunta,
"David Flater" <[EMAIL PROTECTED]> writes:
> PostgreSQL version: 8.2.2
> Description:Nonsense error: "Table has type interval, but query
> expects interval"
See 8.2.3.
regards, tom lane
---(end of broadcast)---
TIP
The following bug has been logged online:
Bug reference: 2983
Logged by: David Flater
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.2
Operating system: Linux
Description:Nonsense error: "Table has type interval, but query
expects interval"
Details:
-- De
The following bug has been logged online:
Bug reference: 2984
Logged by: Gabriel Bravo
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.5
Operating system: Windows XP Professional
Description:Bug Creating or Updating a View
Details:
I had a view created as:
On Thu, Feb 08, 2007 at 11:57:19AM -0500, Bruce Momjian wrote:
> Steven wrote:
> > I have a unique index on a table, but it is still possible to insert a
> > duplicated row, without any message what so ever.
>
> Please show us a self-contained example.
Are you perchance inserting NULL into the co
