openwave 3.1.2
Previous topic Chapter index Next topic

View: vwmilinrheeftbrzo

 

 

Schema

public

 

Owner

waveuser002

 

Descriptions

There is no description for view vwmilinrheeftbrzo

 

Fields

Name

Data type

Description

dnkeymilinrichtingen

integer

 

dlbrzo

char(1)

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Definition

CREATE VIEW public.vwmilinrheeftbrzo (
   dnkeymilinrichtingen,
   dlbrzo)
AS
SELECT
tbmilopslag.dnkeymilinrichtingen,
   max(tbmilopslag.dlbrzo)::character(1) AS dlbrzo
FROM tbmilopslag
WHERE tbmilopslag.dlbrzo = 'T'::bpchar
GROUP BY tbmilopslag.dnkeymilinrichtingen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-01-2013 17:28
Previous topic Chapter index Next topic