I had all this working in UEStudio a couple of years ago but a bizarre crash and UEStudio upgrade to 09.20.0.1003 apparently wiped out my Wordfile.txt changes (and of course it was one of the files I didn't back up).
This CREATE VIEW displays correctly with the correct syntax highlighting. But the function (in fact none of the CREATE VIEW functions) doesn't show up in the Function list. This is pretty annoying because my .sql View files contain up to 50 named views.
The same thing is happening to my PLPGSQL functions. Or, rather, not happening. They're not showing up in the Function list. Here's a typical PLPGSQL function:
Any idea why these aren't populating the the Function List?
I have sort of the opposite problem with PHP. PHP functions are populating the Function List twice -- once with the arguments and once without. But I know what the problem is there. The function parser doesn't like this bracketing style:
If I format the function like this, the function name displays only once:
This CREATE VIEW displays correctly with the correct syntax highlighting. But the function (in fact none of the CREATE VIEW functions) doesn't show up in the Function list. This is pretty annoying because my .sql View files contain up to 50 named views.
Code: Select all
CREATE VIEW view_active_demographic AS
SELECT
demographic_detail.*,
ref_state.abbreviation AS state
FROM
demographic_detail
LEFT JOIN ref_state USING(ref_state_id)
WHERE
demographic_detail.entity_status = ENTITY_ACTIVE();
Code: Select all
CREATE OR REPLACE FUNCTION insert_viewlog (
v_note VARCHAR) RETURNS VOID AS $$
DECLARE
BEGIN
INSERT INTO viewlog (
v_user,
v_text,
v_time)
VALUES (
session_user ,
v_note,
NOW());
END;
$$ LANGUAGE plpgsql;
I have sort of the opposite problem with PHP. PHP functions are populating the Function List twice -- once with the arguments and once without. But I know what the problem is there. The function parser doesn't like this bracketing style:
Code: Select all
function transport_get_private_trips_by_date($trms, $timestamp)
{
if (!is_object($trms) || !is_numeric($timestamp)) {
return array(false, __FUNCTION__ . ': bad arguments');
}
....
}
Code: Select all
function transport_get_private_trips_by_date($trms, $timestamp) {
if (!is_object($trms) || !is_numeric($timestamp)) {
return array(false, __FUNCTION__ . ': bad arguments');
}
....
}