Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwhhstringadvin
Fields
Name | Data type | Description |
---|---|---|
dnkeyhandhavingen |
integer |
|
dvadviesin |
varchar(4000) |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Definition
CREATE VIEW public.vwhhstringadvin (
dnkeyhandhavingen,
dvadviesin)
AS
SELECT tbadviezen.dnkeyhandhavingen,
fnhhget_adviesin(tbadviezen.dnkeyhandhavingen)::character varying(4000) AS
dvadviesin
FROM tbadviezen
WHERE tbadviezen.dnkeyhandhavingen IS NOT NULL AND tbadviezen.ddadviesdatum IS
NOT NULL AND tbadviezen.ddvervallen IS NULL
GROUP BY tbadviezen.dnkeyhandhavingen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
![]() ![]() ![]() |